WIP Repetitive Schedule Data

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Repetitive Schedule Data Report
Application: Work in Process
Source: Repetitive Schedule Data Report (XML)
Short Name: WIPREDAT_XML
DB package: WIP_WIPREDAT_XMLP_PKG
Run WIP Repetitive Schedule Data and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Effective Only 
 
 LOV Oracle
Assemblies From 
 
 LOV Oracle
To 
 
 LOV Oracle
Lines From 
 
 LOV Oracle
To 2 
 
 LOV Oracle
Start Dates From 
 
 Date
To 3 
 
 Date
Download
Related Blitz Reports
CST Periodic WIP Distribution Details INV Inventory Item Upload WIP Value CAC WIP Jobs With Complete Status Which Are Ready for Close CAC WIP Jobs With Complete Status But Not Ready for Close WIP Account Distribution GL SLA Drillback Diagnostic CAC Material Account Summary CAC WIP Account Summary
Blitz Report™

Blitz Report™ provides multiple benefits: