VIEW: APPS.WIPFV_REPETITIVE_SCHEDULES

Source

View Text - Preformatted

SELECT RE.DAILY_PRODUCTION_RATE , RE.PROCESSING_WORK_DAYS , '_LA:re.status_type:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING' , '_LA:re.firm_planned_flag:MFG_LOOKUPS:SYS_YES_NO:MEANING' , RE.FIRST_UNIT_START_DATE , RE.FIRST_UNIT_COMPLETION_DATE , RE.LAST_UNIT_START_DATE , RE.LAST_UNIT_COMPLETION_DATE , RE.DATE_CLOSED , RE.QUANTITY_COMPLETED , RE.BOM_REVISION_DATE , RE.ROUTING_REVISION_DATE , RE.ALTERNATE_BOM_DESIGNATOR , RE.ALTERNATE_ROUTING_DESIGNATOR , RE.DEMAND_CLASS , RE.DATE_RELEASED , '_LA:RE.po_creation_time:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING' , RE.DESCRIPTION , EN.WIP_ENTITY_NAME , PA.ORGANIZATION_CODE , AL.NAME , LI.LINE_CODE , '_KF:INV:MSTK:SY1' , '_KF:INV:MSTK:SY2' , '_KF:INV:MSTK:SY3' , '_KF:SQLGL:GL#:CO1' , '_KF:SQLGL:GL#:CO2' , '_KF:SQLGL:GL#:CO3' , '_KF:SQLGL:GL#:CO4' , '_KF:SQLGL:GL#:CO5' , '_KF:SQLGL:GL#:CO6' , '_KF:SQLGL:GL#:CO7' , '_KF:SQLGL:GL#:CO8' , '_KF:SQLGL:GL#:CO9' , '_DF:WIP:WIP_REPETITIVE_SCHEDULES:RE' , RE.REPETITIVE_SCHEDULE_ID , RE.WIP_ENTITY_ID , RE.ORGANIZATION_ID , RE.LINE_ID , RE.COMMON_BOM_SEQUENCE_ID , RE.COMMON_ROUTING_SEQUENCE_ID , RE.MATERIAL_ACCOUNT , RE.MATERIAL_OVERHEAD_ACCOUNT , RE.RESOURCE_ACCOUNT , RE.OUTSIDE_PROCESSING_ACCOUNT , RE.MATERIAL_VARIANCE_ACCOUNT , RE.RESOURCE_VARIANCE_ACCOUNT , RE.OUTSIDE_PROC_VARIANCE_ACCOUNT , RE.OVERHEAD_ACCOUNT , RE.OVERHEAD_VARIANCE_ACCOUNT , RE.CREATION_DATE , RE.CREATED_BY , RE.LAST_UPDATE_DATE , RE.LAST_UPDATED_BY FROM MTL_SYSTEM_ITEMS SY2 , MTL_SYSTEM_ITEMS SY3 , BOM_BILL_OF_MATERIALS BOM , BOM_OPERATIONAL_ROUTINGS OPRT , MTL_SYSTEM_ITEMS SY1 , WIP_REPETITIVE_ITEMS IT , GL_CODE_COMBINATIONS CO1 , GL_CODE_COMBINATIONS CO2 , GL_CODE_COMBINATIONS CO3 , GL_CODE_COMBINATIONS CO4 , GL_CODE_COMBINATIONS CO5 , GL_CODE_COMBINATIONS CO6 , GL_CODE_COMBINATIONS CO7 , GL_CODE_COMBINATIONS CO8 , GL_CODE_COMBINATIONS CO9 , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , WIP_LINES LI , WIP_ENTITIES EN , WIP_REPETITIVE_SCHEDULES RE WHERE RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND RE.LINE_ID = LI.LINE_ID AND RE.ORGANIZATION_ID = LI.ORGANIZATION_ID AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND RE.MATERIAL_ACCOUNT = CO1.CODE_COMBINATION_ID AND RE.MATERIAL_OVERHEAD_ACCOUNT = CO2.CODE_COMBINATION_ID AND RE.RESOURCE_ACCOUNT = CO3.CODE_COMBINATION_ID AND RE.OUTSIDE_PROCESSING_ACCOUNT = CO4.CODE_COMBINATION_ID AND RE.MATERIAL_VARIANCE_ACCOUNT = CO5.CODE_COMBINATION_ID AND RE.RESOURCE_VARIANCE_ACCOUNT = CO6.CODE_COMBINATION_ID AND RE.OUTSIDE_PROC_VARIANCE_ACCOUNT = CO7.CODE_COMBINATION_ID AND RE.OVERHEAD_ACCOUNT = CO8.CODE_COMBINATION_ID AND RE.OVERHEAD_VARIANCE_ACCOUNT = CO9.CODE_COMBINATION_ID AND RE.LINE_ID = IT.LINE_ID AND RE.WIP_ENTITY_ID = IT.WIP_ENTITY_ID AND RE.ORGANIZATION_ID = IT.ORGANIZATION_ID AND IT.PRIMARY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND IT.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND RE.COMMON_BOM_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID(+) AND RE.COMMON_ROUTING_SEQUENCE_ID = OPRT.ROUTING_SEQUENCE_ID(+) AND BOM.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+) AND BOM.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+) AND OPRT.ASSEMBLY_ITEM_ID = SY3.INVENTORY_ITEM_ID(+) AND OPRT.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+) AND '_SEC:re.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT RE.DAILY_PRODUCTION_RATE
, RE.PROCESSING_WORK_DAYS
, '_LA:RE.STATUS_TYPE:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING'
, '_LA:RE.FIRM_PLANNED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, RE.FIRST_UNIT_START_DATE
, RE.FIRST_UNIT_COMPLETION_DATE
, RE.LAST_UNIT_START_DATE
, RE.LAST_UNIT_COMPLETION_DATE
, RE.DATE_CLOSED
, RE.QUANTITY_COMPLETED
, RE.BOM_REVISION_DATE
, RE.ROUTING_REVISION_DATE
, RE.ALTERNATE_BOM_DESIGNATOR
, RE.ALTERNATE_ROUTING_DESIGNATOR
, RE.DEMAND_CLASS
, RE.DATE_RELEASED
, '_LA:RE.PO_CREATION_TIME:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING'
, RE.DESCRIPTION
, EN.WIP_ENTITY_NAME
, PA.ORGANIZATION_CODE
, AL.NAME
, LI.LINE_CODE
, '_KF:INV:MSTK:SY1'
, '_KF:INV:MSTK:SY2'
, '_KF:INV:MSTK:SY3'
, '_KF:SQLGL:GL#:CO1'
, '_KF:SQLGL:GL#:CO2'
, '_KF:SQLGL:GL#:CO3'
, '_KF:SQLGL:GL#:CO4'
, '_KF:SQLGL:GL#:CO5'
, '_KF:SQLGL:GL#:CO6'
, '_KF:SQLGL:GL#:CO7'
, '_KF:SQLGL:GL#:CO8'
, '_KF:SQLGL:GL#:CO9'
, '_DF:WIP:WIP_REPETITIVE_SCHEDULES:RE'
, RE.REPETITIVE_SCHEDULE_ID
, RE.WIP_ENTITY_ID
, RE.ORGANIZATION_ID
, RE.LINE_ID
, RE.COMMON_BOM_SEQUENCE_ID
, RE.COMMON_ROUTING_SEQUENCE_ID
, RE.MATERIAL_ACCOUNT
, RE.MATERIAL_OVERHEAD_ACCOUNT
, RE.RESOURCE_ACCOUNT
, RE.OUTSIDE_PROCESSING_ACCOUNT
, RE.MATERIAL_VARIANCE_ACCOUNT
, RE.RESOURCE_VARIANCE_ACCOUNT
, RE.OUTSIDE_PROC_VARIANCE_ACCOUNT
, RE.OVERHEAD_ACCOUNT
, RE.OVERHEAD_VARIANCE_ACCOUNT
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY3
, BOM_BILL_OF_MATERIALS BOM
, BOM_OPERATIONAL_ROUTINGS OPRT
, MTL_SYSTEM_ITEMS SY1
, WIP_REPETITIVE_ITEMS IT
, GL_CODE_COMBINATIONS CO1
, GL_CODE_COMBINATIONS CO2
, GL_CODE_COMBINATIONS CO3
, GL_CODE_COMBINATIONS CO4
, GL_CODE_COMBINATIONS CO5
, GL_CODE_COMBINATIONS CO6
, GL_CODE_COMBINATIONS CO7
, GL_CODE_COMBINATIONS CO8
, GL_CODE_COMBINATIONS CO9
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_LINES LI
, WIP_ENTITIES EN
, WIP_REPETITIVE_SCHEDULES RE
WHERE RE.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND RE.LINE_ID = LI.LINE_ID
AND RE.ORGANIZATION_ID = LI.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.MATERIAL_ACCOUNT = CO1.CODE_COMBINATION_ID
AND RE.MATERIAL_OVERHEAD_ACCOUNT = CO2.CODE_COMBINATION_ID
AND RE.RESOURCE_ACCOUNT = CO3.CODE_COMBINATION_ID
AND RE.OUTSIDE_PROCESSING_ACCOUNT = CO4.CODE_COMBINATION_ID
AND RE.MATERIAL_VARIANCE_ACCOUNT = CO5.CODE_COMBINATION_ID
AND RE.RESOURCE_VARIANCE_ACCOUNT = CO6.CODE_COMBINATION_ID
AND RE.OUTSIDE_PROC_VARIANCE_ACCOUNT = CO7.CODE_COMBINATION_ID
AND RE.OVERHEAD_ACCOUNT = CO8.CODE_COMBINATION_ID
AND RE.OVERHEAD_VARIANCE_ACCOUNT = CO9.CODE_COMBINATION_ID
AND RE.LINE_ID = IT.LINE_ID
AND RE.WIP_ENTITY_ID = IT.WIP_ENTITY_ID
AND RE.ORGANIZATION_ID = IT.ORGANIZATION_ID
AND IT.PRIMARY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND RE.COMMON_BOM_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID(+)
AND RE.COMMON_ROUTING_SEQUENCE_ID = OPRT.ROUTING_SEQUENCE_ID(+)
AND BOM.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND BOM.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND OPRT.ASSEMBLY_ITEM_ID = SY3.INVENTORY_ITEM_ID(+)
AND OPRT.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+)
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY