WIP Repetitive Schedule Data

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: Repetitive Schedule Data Report (XML)
Short Name: WIPREDAT_XML
DB package: WIP_WIPREDAT_XMLP_PKG
SELECT WRS.WIP_ENTITY_ID WIP_Entity_ID_CLASS,
       WRS.REPETITIVE_SCHEDULE_ID Repetitive_Schedule_Id,
       WRI.CLASS_CODE Class_Code,
       WAC.DISABLE_DATE Disable_Date,
       WAC.DESCRIPTION Description,
       DECODE(WRS.MATERIAL_ACCOUNT,NULL,NULL,
        null) C_Mtl_Val_Data,
       DECODE(WRS.MATERIAL_OVERHEAD_ACCOUNT,NULL,NULL,
        null) C_Mtl_OH_Val_Data,
       DECODE(WRS.RESOURCE_ACCOUNT,NULL,NULL,
        null) C_Res_Val_Data,
       DECODE(WRS.OUTSIDE_PROCESSING_ACCOUNT,NULL,NULL,
        null) C_Out_Proc_Val_Data,
       DECODE(WRS.OVERHEAD_ACCOUNT,NULL,NULL,
        null) C_OH_Val_Data,
       DECODE(WRS.MATERIAL_VARIANCE_ACCOUNT,NULL,NULL,
        null) C_Mtl_Variance_Data,
       DECODE(WRS.RESOURCE_VARIANCE_ACCOUNT,NULL,NULL,
        null) C_Res_Variance_Data,
       DECODE(WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT,NULL,NULL,
        null) C_Out_Proc_Variance_Data,
       DECODE(WRS.OVERHEAD_VARIANCE_ACCOUNT,NULL,NULL,
        null) C_OH_Variance_Data, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_material_valuation', 'SQLGL', 'GL#', GL1.CHART_OF_ACCOUNTS_ID, NULL, GL1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Material_Valuation, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_mat_ovhead_valuat', 'SQLGL', 'GL#', GL2.CHART_OF_ACCOUNTS_ID, NULL, GL2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Mat_Ovhead_Valuat, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_resource_valuation', 'SQLGL', 'GL#', GL3.CHART_OF_ACCOUNTS_ID, NULL, GL3.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Resource_Valuation, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_outside_proc_valuation', 'SQLGL', 'GL#', GL4.CHART_OF_ACCOUNTS_ID, NULL, GL4.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Outside_Proc_Valuation, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_overhead_valuation', 'SQLGL', 'GL#', GL5.CHART_OF_ACCOUNTS_ID, NULL, GL5.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Overhead_Valuation, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_material_variance', 'SQLGL', 'GL#', GL6.CHART_OF_ACCOUNTS_ID, NULL, GL6.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Material_Variance, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_resource_variance', 'SQLGL', 'GL#', GL8.CHART_OF_ACCOUNTS_ID, NULL, GL8.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Resource_Variance, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_outside_proc_variance', 'SQLGL', 'GL#', GL9.CHART_OF_ACCOUNTS_ID, NULL, GL9.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Outside_Proc_Variance, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_overhead_variance', 'SQLGL', 'GL#', GL10.CHART_OF_ACCOUNTS_ID, NULL, GL10.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Overhead_Variance
FROM   GL_CODE_COMBINATIONS GL1,
       GL_CODE_COMBINATIONS GL2,
       GL_CODE_COMBINATIONS GL3,
       GL_CODE_COMBINATIONS GL4,
       GL_CODE_COMBINATIONS GL5,
       GL_CODE_COMBINATIONS GL6,
       GL_CODE_COMBINATIONS GL8,
       GL_CODE_COMBINATIONS GL9,
       GL_CODE_COMBINATIONS GL10,
       WIP_ACCOUNTING_CLASSES WAC,
       WIP_REPETITIVE_ITEMS WRI,
       WIP_REPETITIVE_SCHEDULES WRS
WHERE  WRS.ORGANIZATION_ID = :P_ORG_ID
AND    WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND    WRI.ORGANIZATION_ID = :P_ORG_ID
AND    WRI.LINE_ID = WRS.LINE_ID
AND    WAC.ORGANIZATION_ID = :P_ORG_ID
AND    WRI.CLASS_CODE = WAC.CLASS_CODE
AND    WRS.MATERIAL_ACCOUNT = GL1.CODE_COMBINATION_ID (+)
AND    WRS.MATERIAL_OVERHEAD_ACCOUNT = GL2.CODE_COMBINATION_ID (+)
AND    WRS.RESOURCE_ACCOUNT = GL3.CODE_COMBINATION_ID (+)
AND    WRS.OUTSIDE_PROCESSING_ACCOUNT = GL4.CODE_COMBINATION_ID (+)
AND    WRS.OVERHEAD_ACCOUNT = GL5.CODE_COMBINATION_ID (+)
AND    WRS.MATERIAL_VARIANCE_ACCOUNT = GL6.CODE_COMBINATION_ID (+)
AND    WRS.RESOURCE_VARIANCE_ACCOUNT = GL8.CODE_COMBINATION_ID (+)
AND    WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT = GL9.CODE_COMBINATION_ID (+)
AND    WRS.OVERHEAD_VARIANCE_ACCOUNT = GL10.CODE_COMBINATION_ID (+)
AND    GL1.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL2.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL3.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL4.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL5.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL6.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL8.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL9.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF
AND    GL10.CHART_OF_ACCOUNTS_ID (+) = :CHART_OF_ACCOUNTS_ID_DEF 
 and WRS.WIP_ENTITY_ID=:WIP_entity_id_SCHED
 and WRS.REPETITIVE_SCHEDULE_ID=:Rep_sched_id_SCHED
Parameter Name SQL text Validation
Chart Of Accounts Id
 
Number
Quanity Field Precision
 
Number
Org_Id
 
Number
To
 
Date
Start Dates From
 
Date
To
 
LOV Oracle
Lines From
 
LOV Oracle
To
 
LOV Oracle
Assemblies From
 
LOV Oracle
Effective Only
 
LOV Oracle