HTML 报表生成过程说明.docx
《HTML 报表生成过程说明.docx》由会员分享，可在线阅读，更多相关《HTML 报表生成过程说明.docx（20页珍藏版）》请在冰豆网上搜索。
HTML报表生成过程说明
HTML报表生成过程说明
【第一部分：
PL/SQL报表模板源码】
CREATEORREPLACEpackageCUX_HP_WJ_HTML_PKGis
/*===============================================================
*Copyright（C）SIEConsultingCo.,LtdAllrightsreserved
*===============================================================
*ProgramName:
CUX_SIE_TRAIN_HTML_WGL_PKG
*Author:
WANGJUN@chinasie.con
*Date:
2011-03-27
*Purpose:
SIE培训HTML报表演示
*
*UpdateHistory
*VersionDateNameDescription
*-----------------------------------------------------
*V1.02011-03-27WANGJUN@chinasie.conCreation
*
===============================================================*/
/*===============================================================
*ProgramName:
cux_inv_onhand_p
*Author:
wanggongliang@chinasie.con
*Date:
2011-03-27
*Purpose:
SIE培训HTML报表演示
*Parameters:
*Inp_organzation_id库存组织ID
*Inp_item物料编码
*Inp_inv_code仓库库别
*OuterrbufORACLE标准需要
*OutretcodeORACLE标准需要
*
*UpdateHistory
*VersionDateNameDescription
*-----------------------------------------------------
*V1.02011-03-27WANGJUN@chinasie.conCreationCreation
*
===============================================================*/
procedurecux_inv_onhand_p（
errbufoutvarchar2,
retcodeoutvarchar2,
p_organzation_idnumber,
p_itemvarchar2,
p_inv_codevarchar2
）;
endCUX_HP_WJ_HTML_PKG;
/
CREATEORREPLACEpackagebodyCUX_HP_WJ_HTML_PKGis
/*===============================================================
*Copyright（C）SIEConsultingCo.,LtdAllrightsreserved
*===============================================================
*ProgramName:
CUX_SIE_TRAIN_HTML_WGL_PKG
*Author:
WANGJUN@chinasie.con
*Date:
2011-03-27
*Purpose:
SIE培训HTML报表演示
*
*UpdateHistory
*VersionDateNameDescription
*-----------------------------------------------------
*V1.02011-03-27WANGJUN@chinasie.conCreation
*
===============================================================*/
/*===============================================================
*ProgramName:
cux_inv_onhand_p
*Author:
wanggongliang@chinasie.con
*Date:
2011-03-27
*Purpose:
SIE培训HTML报表演示
*Parameters:
*Inp_organzation_id库存组织ID
*Inp_item物料编码
*Inp_inv_code仓库库别
*OuterrbufORACLE标准需要
*OutretcodeORACLE标准需要
*
*UpdateHistory
*VersionDateNameDescription
*-----------------------------------------------------
*V1.02011-03-27WANGJUN@chinasie.conCreationCreation
*
===============================================================*/
procedurecux_inv_onhand_p（
errbufoutvarchar2,
retcodeoutvarchar2,
p_organzation_idnumber,
p_itemvarchar2,
p_inv_codevarchar2
）
is
cursorc_onhand_qty
is
selectmsi.organization_id,
msi.segment1,
msi.description,
sum（moq.transaction_quantity）onhand_qty,
moq.subinventory_code
frommtl_onhand_quantities_detailmoq,mtl_system_items_bmsi
wheremoq.organization_id=msi.organization_id
--andmoq.inventory_item_id=nvl（msi.inventory_item_id,moq.inventory_item_id）
andmsi.organization_id=nvl（p_organzation_id,msi.organization_id）
andmsi.segment1=nvl（p_item,msi.segment1）
andmoq.subinventory_code=nvl（p_inv_code,moq.subinventory_code）
groupbymsi.organization_id,msi.segment1,msi.description,moq.subinventory_code;
v_sepvarchar2（20）;
v_line_strvarchar2（3000）;
v_bkg_colorvarchar2（3000）;
begin
HTML_REPORT_WGL_PKG.v_report_output_mode:
='F';
v_sep:
='@';
-----定义报表和网页名称
HTML_REPORT_WGL_PKG.html_title（p_program_title=>'库存现有量报表',
p_report_title=>'库存现有量报表'）;
-----定义报表的列名
HTML_REPORT_WGL_PKG.output_line（p_output_str=>'collapse;border:
none;font-family:
宋体;font-size:
9pt"border=1bordercolor=#000000cellspacing="0">'）;
---报表的列表
v_line_str:
='库存组织ID,物料编码,物料描述,库别,库存现有量,';
HTML_REPORT_WGL_PKG.line_title（p_title_string=>v_line_str,
p_with_other_attr=>'Y',
p_attr_delimiter=>'*'）;
---输出报表内容
forr_onhandinc_onhand_qtyloop
/*v_bkg_color:
='***bgcolor=rgb（200,200,200）';*/
-----报表内容项目的值与HTML语言格式进行关联
v_line_str:
=r_onhand.organization_id||v_bkg_color||v_sep||
r_onhand.segment1||v_bkg_color||v_sep||
r_onhand.description||v_bkg_color||v_sep||
r_onhand.subinventory_code||v_bkg_color||v_sep||
r_onhand.onhand_qty||v_bkg_color||v_sep;
HTML_REPORT_WGL_PKG.line_title（p_title_string=>v_line_str,
p_delimiter=>v_sep,
p_with_other_attr=>'Y',
p_attr_delimiter=>'***'）;
endloop;
end;
endCUX_HP_WJ_HTML_PKG;
【第二部分：
在ORACLEEBS中发布HTML报表】
MFG_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
SEGMENT1
DESCRIPTION
WHEREORGANIZATION_ID=:
$PROFILES$.MFG_ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES
SECONDARY_INVENTORY_NAME
WHEREORGANIZATION_ID=:
$PROFILES$.MFG_ORGANIZATION_ID
【注意】要选择“制造系统“
【测试步骤】
升级会员 