WIP Repetitive Schedule Data

Description
Categories: BI Publisher
Columns: Wip Entity Id Class, Repetitive Schedule Id, Class Code, Disable Date, Description, C Mtl Val Data, C Mtl Oh Val Data, C Res Val Data, C Out Proc Val Data, C Oh Val Data ...
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
Effective Only
 
LOV Oracle
Assemblies From
 
LOV Oracle
To
 
LOV Oracle
Lines From
 
LOV Oracle
To
 
LOV Oracle
Start Dates From
 
Date
To
 
Date
Org_Id
 
Number
Quanity Field Precision
 
Number
Chart Of Accounts Id
 
Number