select sch.Consign_Title,
Cs.Consign_Supplier_Id,
ssi.src_sourcing_number as src_sourcing_number,
Sbi.Supplier_Name,
Cs.Supplier_Code,
to_char(ssi.Sourcing_Date,'yyyy') bid_year,
to_char(ssi.Sourcing_Date,'mm') bid_month,
to_char(ssi.Sourcing_Date,'dd') bid_day,
(select to_char(wwi.last_update_date,'yyyy') from wfl_workflow_instance wwi where wwi.instance_param =${/parameter/@p_header_id} AND wwi.Status>0) br_year,
(select to_char(wwi.last_update_date,'mm') from wfl_workflow_instance wwi where wwi.instance_param =${/parameter/@p_header_id} AND wwi.Status >0) br_month,
(select to_char(wwi.last_update_date,'dd') from wfl_workflow_instance wwi where wwi.instance_param =${/parameter/@p_header_id} AND wwi.Status >0) br_day,
to_char(Src_Order_Pkg.Get_Bid_Total(${/parameter/@p_header_id},Cs.Supplier_Code),'B999,999,999,999.99') as bid_price,
Money_To_Chinese(Src_Order_Pkg.Get_Bid_Total(${/parameter/@p_header_id},Cs.Supplier_Code)) as Bid_Price_Chinese,
src_wfl_order_pkg.validate_bid(cs.supplier_code,${/parameter/@p_header_id}) as bid_flag,
decode(src_wfl_order_pkg.validate_bid(cs.supplier_code,${/parameter/@p_header_id}),0,'落标','中标') as bid_status,
Cs.Bid_Comment
from Spl_Suppliers_Base_Info_v Sbi,
Src_Consign_Suppliers Cs,
src_consign_headers sch,
src_sourcing_info ssi
where Cs.Consign_Header_Id =${/parameter/@p_header_id}
and sch.Consign_Header_Id=cs.Consign_Header_Id
and sch.Consign_Header_Id=ssi.Consign_Header_Id
and Cs.Supplier_Code = Sbi.Supplier_Code
and Cs.Version_Status = 'Y'
and ssi.Version_Status = 'Y'
AND sbi.supplier_type = decode(sch.consign_type,'SPEC_SOURCING','BID_COMPANY','SOURCING_COMPANY')
and sbi.supplier_code=${/parameter/@p_supplier_code}这个脚本里面的 sbi.supplier_code=${/parameter/@p_supplier_code}
是什么意思啊!
Cs.Consign_Supplier_Id,
ssi.src_sourcing_number as src_sourcing_number,
Sbi.Supplier_Name,
Cs.Supplier_Code,
to_char(ssi.Sourcing_Date,'yyyy') bid_year,
to_char(ssi.Sourcing_Date,'mm') bid_month,
to_char(ssi.Sourcing_Date,'dd') bid_day,
(select to_char(wwi.last_update_date,'yyyy') from wfl_workflow_instance wwi where wwi.instance_param =${/parameter/@p_header_id} AND wwi.Status>0) br_year,
(select to_char(wwi.last_update_date,'mm') from wfl_workflow_instance wwi where wwi.instance_param =${/parameter/@p_header_id} AND wwi.Status >0) br_month,
(select to_char(wwi.last_update_date,'dd') from wfl_workflow_instance wwi where wwi.instance_param =${/parameter/@p_header_id} AND wwi.Status >0) br_day,
to_char(Src_Order_Pkg.Get_Bid_Total(${/parameter/@p_header_id},Cs.Supplier_Code),'B999,999,999,999.99') as bid_price,
Money_To_Chinese(Src_Order_Pkg.Get_Bid_Total(${/parameter/@p_header_id},Cs.Supplier_Code)) as Bid_Price_Chinese,
src_wfl_order_pkg.validate_bid(cs.supplier_code,${/parameter/@p_header_id}) as bid_flag,
decode(src_wfl_order_pkg.validate_bid(cs.supplier_code,${/parameter/@p_header_id}),0,'落标','中标') as bid_status,
Cs.Bid_Comment
from Spl_Suppliers_Base_Info_v Sbi,
Src_Consign_Suppliers Cs,
src_consign_headers sch,
src_sourcing_info ssi
where Cs.Consign_Header_Id =${/parameter/@p_header_id}
and sch.Consign_Header_Id=cs.Consign_Header_Id
and sch.Consign_Header_Id=ssi.Consign_Header_Id
and Cs.Supplier_Code = Sbi.Supplier_Code
and Cs.Version_Status = 'Y'
and ssi.Version_Status = 'Y'
AND sbi.supplier_type = decode(sch.consign_type,'SPEC_SOURCING','BID_COMPANY','SOURCING_COMPANY')
and sbi.supplier_code=${/parameter/@p_supplier_code}这个脚本里面的 sbi.supplier_code=${/parameter/@p_supplier_code}
是什么意思啊!
--这种写法倒是有 以后拼接sql语句就不用那么麻烦了 1* select q'{/parameter/@p_supplier_code}' from dual
scott@YPCOST> /Q'{/PARAMETER/@P_SUPPLIER_C
---------------------------
/parameter/@p_supplier_code
没见过 应该是xml那边的
16页
看了后反应过来了,印象中是有。
你可以去我的下载看看.刚传了一个上去
http://minitoy.download.csdn.net/
$P{objectid}见过,传一个参数
${/parameter/@p_supplier_code}没见过