VIEW: APPS.WIPFV_WIP_JOBS

Source

View Text - Preformatted

SELECT EN.WIP_ENTITY_NAME , '_LA:di.status_type:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING' , '_LA:di.firm_planned_flag:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:di.job_type:MFG_LOOKUPS:WIP_DISCRETE_JOB:MEANING' , '_LA:di.wip_supply_type:MFG_LOOKUPS:WIP_SUPPLY:MEANING' , DI.SCHEDULED_START_DATE , DI.SCHEDULED_COMPLETION_DATE , DI.START_QUANTITY , DI.DATE_RELEASED , DI.DATE_COMPLETED , DI.DATE_CLOSED , DI.QUANTITY_COMPLETED , DI.QUANTITY_SCRAPPED , DI.NET_QUANTITY , DI.BOM_REVISION_DATE , DI.ROUTING_REVISION_DATE , DI.LOT_NUMBER , DI.ALTERNATE_BOM_DESIGNATOR , DI.ALTERNATE_ROUTING_DESIGNATOR , DI.BUILD_SEQUENCE , DI.DEMAND_CLASS , '_LA:di.po_creation_time:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING' , DI.END_ITEM_UNIT_NUMBER , '_LA:DI.OVERCOMPLETION_TOLERANCE_TYPE:MFG_LOOKUPS:WIP_TOLERANCE_TYPE:MEANING' , DI.OVERCOMPLETION_TOLERANCE_VALUE , DI.DESCRIPTION , PA.ORGANIZATION_CODE , AL.NAME , '_KF:INV:MSTK:sy1' , '_KF:INV:MSTK:sy2' , '_KF:INV:MSTK:sy3' , '_KF:INV:MSTK:sy4' , '_KF:INV:MSTK:sy5' , ITLO.DESCRIPTION , SC.SCHEDULE_GROUP_NAME , LI.LINE_CODE , PR.PROJECT_NUMBER , PR.PROJECT_NAME , TA.TASK_NUMBER , TA.TASK_NAME , KA.KANBAN_CARD_NUMBER , '_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' , '_KF:SQLGL:GL#:co10' , '_DF:WIP:WIP_DISCRETE_JOBS:DI' , DI.WIP_ENTITY_ID , DI.ORGANIZATION_ID , DI.PRIMARY_ITEM_ID , DI.CLASS_CODE , DI.BOM_REFERENCE_ID , DI.ROUTING_REFERENCE_ID , DI.COMMON_BOM_SEQUENCE_ID , DI.COMMON_ROUTING_SEQUENCE_ID , DI.BOM_REVISION , DI.ROUTING_REVISION , DI.COMPLETION_SUBINVENTORY , DI.COMPLETION_LOCATOR_ID , DI.SCHEDULE_GROUP_ID , DI.LINE_ID , DI.PROJECT_ID , DI.TASK_ID , DI.KANBAN_CARD_ID , DI.MATERIAL_ACCOUNT , DI.MATERIAL_OVERHEAD_ACCOUNT , DI.RESOURCE_ACCOUNT , DI.OUTSIDE_PROCESSING_ACCOUNT , DI.MATERIAL_VARIANCE_ACCOUNT , DI.RESOURCE_VARIANCE_ACCOUNT , DI.OUTSIDE_PROC_VARIANCE_ACCOUNT , DI.STD_COST_ADJUSTMENT_ACCOUNT , DI.OVERHEAD_ACCOUNT , DI.OVERHEAD_VARIANCE_ACCOUNT , DI.CREATION_DATE , DI.CREATED_BY , DI.LAST_UPDATE_DATE , DI.LAST_UPDATED_BY FROM MTL_SYSTEM_ITEMS SY1 , MTL_SYSTEM_ITEMS SY2 , MTL_SYSTEM_ITEMS SY3 , MTL_SYSTEM_ITEMS SY4 , MTL_SYSTEM_ITEMS SY5 , BOM_BILL_OF_MATERIALS BOM , BOM_OPERATIONAL_ROUTINGS OPRT , MTL_ITEM_LOCATIONS ITLO , MTL_ITEM_REVISIONS ITRE , MTL_RTG_ITEM_REVISIONS RT , MTL_SECONDARY_INVENTORIES SEIN , WIP_SCHEDULE_GROUPS SC , WIP_LINES LI , PJMFV_PROJECT_MFG_PROJECTS PR , PJM_UNIT_NUMBERS UN , PA_TASKS TA , MTL_KANBAN_CARDS KA , 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 , GL_CODE_COMBINATIONS CO10 , WIP_ENTITIES EN , WIP_ACCOUNTING_CLASSES AC , MTL_PARAMETERS PA , HR_ALL_ORGANIZATION_UNITS AL , WIP_DISCRETE_JOBS DI WHERE DI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND DI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND DI.CLASS_CODE = AC.CLASS_CODE AND DI.ORGANIZATION_ID = AC.ORGANIZATION_ID AND DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID AND DI.MATERIAL_ACCOUNT = CO1.CODE_COMBINATION_ID(+) AND DI.MATERIAL_OVERHEAD_ACCOUNT = CO2.CODE_COMBINATION_ID(+) AND DI.RESOURCE_ACCOUNT = CO3.CODE_COMBINATION_ID(+) AND DI.OUTSIDE_PROCESSING_ACCOUNT = CO4.CODE_COMBINATION_ID(+) AND DI.MATERIAL_VARIANCE_ACCOUNT = CO5.CODE_COMBINATION_ID(+) AND DI.RESOURCE_VARIANCE_ACCOUNT = CO6.CODE_COMBINATION_ID(+) AND DI.OUTSIDE_PROC_VARIANCE_ACCOUNT = CO7.CODE_COMBINATION_ID(+) AND DI.STD_COST_ADJUSTMENT_ACCOUNT = CO8.CODE_COMBINATION_ID(+) AND DI.OVERHEAD_ACCOUNT = CO9.CODE_COMBINATION_ID(+) AND DI.OVERHEAD_VARIANCE_ACCOUNT = CO10.CODE_COMBINATION_ID(+) AND DI.PROJECT_ID = PR.PROJECT_ID(+) AND DI.END_ITEM_UNIT_NUMBER = UN.UNIT_NUMBER(+) AND DI.TASK_ID = TA.TASK_ID(+) AND DI.KANBAN_CARD_ID = KA.KANBAN_CARD_ID(+) AND DI.LINE_ID = LI.LINE_ID(+) AND DI.ORGANIZATION_ID = LI.ORGANIZATION_ID(+) AND DI.SCHEDULE_GROUP_ID = SC.SCHEDULE_GROUP_ID(+) AND DI.COMPLETION_SUBINVENTORY = SEIN.SECONDARY_INVENTORY_NAME(+) AND DI.ORGANIZATION_ID = SEIN.ORGANIZATION_ID(+) AND DI.COMPLETION_LOCATOR_ID = ITLO.INVENTORY_LOCATION_ID(+) AND DI.ORGANIZATION_ID = ITLO.ORGANIZATION_ID(+) AND DI.PRIMARY_ITEM_ID = ITRE.INVENTORY_ITEM_ID(+) AND DI.ORGANIZATION_ID = ITRE.ORGANIZATION_ID(+) AND DI.BOM_REVISION = ITRE.REVISION(+) AND DI.ROUTING_REVISION = RT.PROCESS_REVISION(+) AND DI.PRIMARY_ITEM_ID = RT.INVENTORY_ITEM_ID(+) AND DI.ORGANIZATION_ID = RT.ORGANIZATION_ID(+) AND DI.PRIMARY_ITEM_ID = SY1.INVENTORY_ITEM_ID(+) AND DI.ORGANIZATION_ID = SY1.ORGANIZATION_ID(+) AND DI.BOM_REFERENCE_ID = SY2.INVENTORY_ITEM_ID(+) AND DI.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+) AND DI.ROUTING_REFERENCE_ID = SY3.INVENTORY_ITEM_ID(+) AND DI.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+) AND DI.COMMON_BOM_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID(+) AND BOM.ASSEMBLY_ITEM_ID = SY4.INVENTORY_ITEM_ID(+) AND BOM.ORGANIZATION_ID = SY4.ORGANIZATION_ID(+) AND DI.COMMON_ROUTING_SEQUENCE_ID = OPRT.ROUTING_SEQUENCE_ID(+) AND OPRT.ASSEMBLY_ITEM_ID = SY5.INVENTORY_ITEM_ID(+) AND OPRT.ORGANIZATION_ID = SY5.ORGANIZATION_ID(+) AND '_SEC:di.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT EN.WIP_ENTITY_NAME
, '_LA:DI.STATUS_TYPE:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING'
, '_LA:DI.FIRM_PLANNED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:DI.JOB_TYPE:MFG_LOOKUPS:WIP_DISCRETE_JOB:MEANING'
, '_LA:DI.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, DI.SCHEDULED_START_DATE
, DI.SCHEDULED_COMPLETION_DATE
, DI.START_QUANTITY
, DI.DATE_RELEASED
, DI.DATE_COMPLETED
, DI.DATE_CLOSED
, DI.QUANTITY_COMPLETED
, DI.QUANTITY_SCRAPPED
, DI.NET_QUANTITY
, DI.BOM_REVISION_DATE
, DI.ROUTING_REVISION_DATE
, DI.LOT_NUMBER
, DI.ALTERNATE_BOM_DESIGNATOR
, DI.ALTERNATE_ROUTING_DESIGNATOR
, DI.BUILD_SEQUENCE
, DI.DEMAND_CLASS
, '_LA:DI.PO_CREATION_TIME:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING'
, DI.END_ITEM_UNIT_NUMBER
, '_LA:DI.OVERCOMPLETION_TOLERANCE_TYPE:MFG_LOOKUPS:WIP_TOLERANCE_TYPE:MEANING'
, DI.OVERCOMPLETION_TOLERANCE_VALUE
, DI.DESCRIPTION
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY1'
, '_KF:INV:MSTK:SY2'
, '_KF:INV:MSTK:SY3'
, '_KF:INV:MSTK:SY4'
, '_KF:INV:MSTK:SY5'
, ITLO.DESCRIPTION
, SC.SCHEDULE_GROUP_NAME
, LI.LINE_CODE
, PR.PROJECT_NUMBER
, PR.PROJECT_NAME
, TA.TASK_NUMBER
, TA.TASK_NAME
, KA.KANBAN_CARD_NUMBER
, '_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'
, '_KF:SQLGL:GL#:CO10'
, '_DF:WIP:WIP_DISCRETE_JOBS:DI'
, DI.WIP_ENTITY_ID
, DI.ORGANIZATION_ID
, DI.PRIMARY_ITEM_ID
, DI.CLASS_CODE
, DI.BOM_REFERENCE_ID
, DI.ROUTING_REFERENCE_ID
, DI.COMMON_BOM_SEQUENCE_ID
, DI.COMMON_ROUTING_SEQUENCE_ID
, DI.BOM_REVISION
, DI.ROUTING_REVISION
, DI.COMPLETION_SUBINVENTORY
, DI.COMPLETION_LOCATOR_ID
, DI.SCHEDULE_GROUP_ID
, DI.LINE_ID
, DI.PROJECT_ID
, DI.TASK_ID
, DI.KANBAN_CARD_ID
, DI.MATERIAL_ACCOUNT
, DI.MATERIAL_OVERHEAD_ACCOUNT
, DI.RESOURCE_ACCOUNT
, DI.OUTSIDE_PROCESSING_ACCOUNT
, DI.MATERIAL_VARIANCE_ACCOUNT
, DI.RESOURCE_VARIANCE_ACCOUNT
, DI.OUTSIDE_PROC_VARIANCE_ACCOUNT
, DI.STD_COST_ADJUSTMENT_ACCOUNT
, DI.OVERHEAD_ACCOUNT
, DI.OVERHEAD_VARIANCE_ACCOUNT
, DI.CREATION_DATE
, DI.CREATED_BY
, DI.LAST_UPDATE_DATE
, DI.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY1
, MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY3
, MTL_SYSTEM_ITEMS SY4
, MTL_SYSTEM_ITEMS SY5
, BOM_BILL_OF_MATERIALS BOM
, BOM_OPERATIONAL_ROUTINGS OPRT
, MTL_ITEM_LOCATIONS ITLO
, MTL_ITEM_REVISIONS ITRE
, MTL_RTG_ITEM_REVISIONS RT
, MTL_SECONDARY_INVENTORIES SEIN
, WIP_SCHEDULE_GROUPS SC
, WIP_LINES LI
, PJMFV_PROJECT_MFG_PROJECTS PR
, PJM_UNIT_NUMBERS UN
, PA_TASKS TA
, MTL_KANBAN_CARDS KA
, 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
, GL_CODE_COMBINATIONS CO10
, WIP_ENTITIES EN
, WIP_ACCOUNTING_CLASSES AC
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, WIP_DISCRETE_JOBS DI
WHERE DI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND DI.CLASS_CODE = AC.CLASS_CODE
AND DI.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND DI.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND DI.MATERIAL_ACCOUNT = CO1.CODE_COMBINATION_ID(+)
AND DI.MATERIAL_OVERHEAD_ACCOUNT = CO2.CODE_COMBINATION_ID(+)
AND DI.RESOURCE_ACCOUNT = CO3.CODE_COMBINATION_ID(+)
AND DI.OUTSIDE_PROCESSING_ACCOUNT = CO4.CODE_COMBINATION_ID(+)
AND DI.MATERIAL_VARIANCE_ACCOUNT = CO5.CODE_COMBINATION_ID(+)
AND DI.RESOURCE_VARIANCE_ACCOUNT = CO6.CODE_COMBINATION_ID(+)
AND DI.OUTSIDE_PROC_VARIANCE_ACCOUNT = CO7.CODE_COMBINATION_ID(+)
AND DI.STD_COST_ADJUSTMENT_ACCOUNT = CO8.CODE_COMBINATION_ID(+)
AND DI.OVERHEAD_ACCOUNT = CO9.CODE_COMBINATION_ID(+)
AND DI.OVERHEAD_VARIANCE_ACCOUNT = CO10.CODE_COMBINATION_ID(+)
AND DI.PROJECT_ID = PR.PROJECT_ID(+)
AND DI.END_ITEM_UNIT_NUMBER = UN.UNIT_NUMBER(+)
AND DI.TASK_ID = TA.TASK_ID(+)
AND DI.KANBAN_CARD_ID = KA.KANBAN_CARD_ID(+)
AND DI.LINE_ID = LI.LINE_ID(+)
AND DI.ORGANIZATION_ID = LI.ORGANIZATION_ID(+)
AND DI.SCHEDULE_GROUP_ID = SC.SCHEDULE_GROUP_ID(+)
AND DI.COMPLETION_SUBINVENTORY = SEIN.SECONDARY_INVENTORY_NAME(+)
AND DI.ORGANIZATION_ID = SEIN.ORGANIZATION_ID(+)
AND DI.COMPLETION_LOCATOR_ID = ITLO.INVENTORY_LOCATION_ID(+)
AND DI.ORGANIZATION_ID = ITLO.ORGANIZATION_ID(+)
AND DI.PRIMARY_ITEM_ID = ITRE.INVENTORY_ITEM_ID(+)
AND DI.ORGANIZATION_ID = ITRE.ORGANIZATION_ID(+)
AND DI.BOM_REVISION = ITRE.REVISION(+)
AND DI.ROUTING_REVISION = RT.PROCESS_REVISION(+)
AND DI.PRIMARY_ITEM_ID = RT.INVENTORY_ITEM_ID(+)
AND DI.ORGANIZATION_ID = RT.ORGANIZATION_ID(+)
AND DI.PRIMARY_ITEM_ID = SY1.INVENTORY_ITEM_ID(+)
AND DI.ORGANIZATION_ID = SY1.ORGANIZATION_ID(+)
AND DI.BOM_REFERENCE_ID = SY2.INVENTORY_ITEM_ID(+)
AND DI.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND DI.ROUTING_REFERENCE_ID = SY3.INVENTORY_ITEM_ID(+)
AND DI.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+)
AND DI.COMMON_BOM_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID(+)
AND BOM.ASSEMBLY_ITEM_ID = SY4.INVENTORY_ITEM_ID(+)
AND BOM.ORGANIZATION_ID = SY4.ORGANIZATION_ID(+)
AND DI.COMMON_ROUTING_SEQUENCE_ID = OPRT.ROUTING_SEQUENCE_ID(+)
AND OPRT.ASSEMBLY_ITEM_ID = SY5.INVENTORY_ITEM_ID(+)
AND OPRT.ORGANIZATION_ID = SY5.ORGANIZATION_ID(+)
AND '_SEC:DI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY