VIEW: APPS.WIP_DISCRETE_JOBS_V

Source

View Text - Preformatted

SELECT WDJ.ROWID ROW_ID , WDJ.WIP_ENTITY_ID , WE.WIP_ENTITY_NAME , WE.ROWID WE_ROW_ID , WDJ.ORGANIZATION_ID , WDJ.LAST_UPDATE_DATE , WDJ.LAST_UPDATED_BY , WDJ.CREATION_DATE , WDJ.CREATED_BY , WDJ.LAST_UPDATE_LOGIN , WDJ.REQUEST_ID , WDJ.PROGRAM_APPLICATION_ID , WDJ.PROGRAM_ID , WDJ.PROGRAM_UPDATE_DATE , WDJ.DESCRIPTION , WDJ.STATUS_TYPE , WDJ.PRIMARY_ITEM_ID , WDJ.FIRM_PLANNED_FLAG , WDJ.JOB_TYPE , LU3.MEANING , WDJ.WIP_SUPPLY_TYPE , WDJ.CLASS_CODE , WDJ.MATERIAL_ACCOUNT , WDJ.MATERIAL_OVERHEAD_ACCOUNT , WDJ.RESOURCE_ACCOUNT , WDJ.OUTSIDE_PROCESSING_ACCOUNT , WDJ.MATERIAL_VARIANCE_ACCOUNT , WDJ.RESOURCE_VARIANCE_ACCOUNT , WDJ.OUTSIDE_PROC_VARIANCE_ACCOUNT , WDJ.STD_COST_ADJUSTMENT_ACCOUNT , WDJ.OVERHEAD_ACCOUNT , WDJ.OVERHEAD_VARIANCE_ACCOUNT , WDJ.SCHEDULED_START_DATE , WDJ.DATE_RELEASED , WDJ.SCHEDULED_COMPLETION_DATE , WDJ.DATE_COMPLETED , WDJ.DATE_CLOSED , WDJ.START_QUANTITY , DECODE(WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED,0,NULL,WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED) "QUANTITY_REMAINING" , DECODE(WDJ.QUANTITY_COMPLETED,0,NULL,WDJ.QUANTITY_COMPLETED) "QUANTITY_COMPLETED" , DECODE(WDJ.QUANTITY_SCRAPPED,0,NULL,WDJ.QUANTITY_SCRAPPED) "QUANTITY_SCRAPPED" , WDJ.NET_QUANTITY , WDJ.BOM_REFERENCE_ID , WDJ.ROUTING_REFERENCE_ID , WDJ.COMMON_BOM_SEQUENCE_ID , WDJ.COMMON_ROUTING_SEQUENCE_ID , WDJ.BOM_REVISION , WDJ.ROUTING_REVISION , WDJ.BOM_REVISION_DATE , WDJ.ROUTING_REVISION_DATE , WDJ.LOT_NUMBER , WDJ.ALTERNATE_BOM_DESIGNATOR , WDJ.ALTERNATE_ROUTING_DESIGNATOR , WDJ.COMPLETION_SUBINVENTORY , WDJ.COMPLETION_LOCATOR_ID , DECODE(WDJ.COMPLETION_SUBINVENTORY,NULL,1,MSUB.LOCATOR_TYPE) SUB_LOCATOR_CONTROL , WDJ.DEMAND_CLASS ,WSG.SCHEDULE_GROUP_NAME ,WDJ.SCHEDULE_GROUP_ID ,WDJ.BUILD_SEQUENCE ,WL.LINE_CODE ,WDJ.LINE_ID ,PJM_PROJECT.ALL_PROJ_IDTONAME(WDJ.PROJECT_ID) PROJECT_NAME ,PJM_PROJECT.ALL_PROJ_IDTONUM(WDJ.PROJECT_ID) PROJECT_NUMBER ,WDJ.PROJECT_ID ,PJM_PROJECT.ALL_TASK_IDTONAME(WDJ.TASK_ID)TASK_NAME ,PJM_PROJECT.ALL_TASK_IDTONUM(WDJ.TASK_ID)TASK_NUMBER ,WDJ.TASK_ID ,WDJ.END_ITEM_UNIT_NUMBER , WDJ.ATTRIBUTE_CATEGORY , WDJ.ATTRIBUTE1 , WDJ.ATTRIBUTE2 , WDJ.ATTRIBUTE3 , WDJ.ATTRIBUTE4 , WDJ.ATTRIBUTE5 , WDJ.ATTRIBUTE6 , WDJ.ATTRIBUTE7 , WDJ.ATTRIBUTE8 , WDJ.ATTRIBUTE9 , WDJ.ATTRIBUTE10 , WDJ.ATTRIBUTE11 , WDJ.ATTRIBUTE12 , WDJ.ATTRIBUTE13 , WDJ.ATTRIBUTE14 , WDJ.ATTRIBUTE15 , LU1.MEANING STATUS_TYPE_DISP , LU2.MEANING WIP_SUPPLY_TYPE_DISP ,WDJ.OVERCOMPLETION_TOLERANCE_TYPE ,WDJ.OVERCOMPLETION_TOLERANCE_VALUE , WDJ.KANBAN_CARD_ID , KC.KANBAN_CARD_NUMBER ,WDJ.PO_CREATION_TIME ,WDJ.PRIORITY ,WDJ.DUE_DATE ,WDJ.EST_SCRAP_ACCOUNT ,WDJ.EST_SCRAP_VAR_ACCOUNT , WE.ENTITY_TYPE , WDJ.DUE_DATE_PENALTY , WDJ.DUE_DATE_TOLERANCE ,WDJ.COPRODUCTS_SUPPLY ,WDJ.REQUESTED_START_DATE ,WDJ.SERIALIZATION_START_OP ,WDJ.ACTUAL_START_DATE ,WDJ.EXPECTED_HOLD_RELEASE_DATE FROM MTL_SECONDARY_INVENTORIES MSUB , MFG_LOOKUPS LU1 , MFG_LOOKUPS LU2 , MFG_LOOKUPS LU3 , WIP_ENTITIES WE , WIP_DISCRETE_JOBS WDJ , WIP_LINES WL , WIP_SCHEDULE_GROUPS WSG , MTL_KANBAN_CARDS KC WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND MSUB.SECONDARY_INVENTORY_NAME (+) = WDJ.COMPLETION_SUBINVENTORY AND MSUB.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID AND WSG.SCHEDULE_GROUP_ID (+) = WDJ.SCHEDULE_GROUP_ID AND WL.LINE_ID (+) = WDJ.LINE_ID AND WL.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID AND LU2.LOOKUP_TYPE = 'WIP_SUPPLY' AND LU1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND LU3.LOOKUP_TYPE = 'WIP_DISCRETE_JOB' AND LU1.LOOKUP_CODE = WDJ.STATUS_TYPE AND LU2.LOOKUP_CODE = WDJ.WIP_SUPPLY_TYPE AND LU3.LOOKUP_CODE = WDJ.JOB_TYPE AND KC.KANBAN_CARD_ID (+) = WDJ.KANBAN_CARD_ID

View Text - HTML Formatted

SELECT WDJ.ROWID ROW_ID
, WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WE.ROWID WE_ROW_ID
, WDJ.ORGANIZATION_ID
, WDJ.LAST_UPDATE_DATE
, WDJ.LAST_UPDATED_BY
, WDJ.CREATION_DATE
, WDJ.CREATED_BY
, WDJ.LAST_UPDATE_LOGIN
, WDJ.REQUEST_ID
, WDJ.PROGRAM_APPLICATION_ID
, WDJ.PROGRAM_ID
, WDJ.PROGRAM_UPDATE_DATE
, WDJ.DESCRIPTION
, WDJ.STATUS_TYPE
, WDJ.PRIMARY_ITEM_ID
, WDJ.FIRM_PLANNED_FLAG
, WDJ.JOB_TYPE
, LU3.MEANING
, WDJ.WIP_SUPPLY_TYPE
, WDJ.CLASS_CODE
, WDJ.MATERIAL_ACCOUNT
, WDJ.MATERIAL_OVERHEAD_ACCOUNT
, WDJ.RESOURCE_ACCOUNT
, WDJ.OUTSIDE_PROCESSING_ACCOUNT
, WDJ.MATERIAL_VARIANCE_ACCOUNT
, WDJ.RESOURCE_VARIANCE_ACCOUNT
, WDJ.OUTSIDE_PROC_VARIANCE_ACCOUNT
, WDJ.STD_COST_ADJUSTMENT_ACCOUNT
, WDJ.OVERHEAD_ACCOUNT
, WDJ.OVERHEAD_VARIANCE_ACCOUNT
, WDJ.SCHEDULED_START_DATE
, WDJ.DATE_RELEASED
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.DATE_COMPLETED
, WDJ.DATE_CLOSED
, WDJ.START_QUANTITY
, DECODE(WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED
, 0
, NULL
, WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED) "QUANTITY_REMAINING"
, DECODE(WDJ.QUANTITY_COMPLETED
, 0
, NULL
, WDJ.QUANTITY_COMPLETED) "QUANTITY_COMPLETED"
, DECODE(WDJ.QUANTITY_SCRAPPED
, 0
, NULL
, WDJ.QUANTITY_SCRAPPED) "QUANTITY_SCRAPPED"
, WDJ.NET_QUANTITY
, WDJ.BOM_REFERENCE_ID
, WDJ.ROUTING_REFERENCE_ID
, WDJ.COMMON_BOM_SEQUENCE_ID
, WDJ.COMMON_ROUTING_SEQUENCE_ID
, WDJ.BOM_REVISION
, WDJ.ROUTING_REVISION
, WDJ.BOM_REVISION_DATE
, WDJ.ROUTING_REVISION_DATE
, WDJ.LOT_NUMBER
, WDJ.ALTERNATE_BOM_DESIGNATOR
, WDJ.ALTERNATE_ROUTING_DESIGNATOR
, WDJ.COMPLETION_SUBINVENTORY
, WDJ.COMPLETION_LOCATOR_ID
, DECODE(WDJ.COMPLETION_SUBINVENTORY
, NULL
, 1
, MSUB.LOCATOR_TYPE) SUB_LOCATOR_CONTROL
, WDJ.DEMAND_CLASS
, WSG.SCHEDULE_GROUP_NAME
, WDJ.SCHEDULE_GROUP_ID
, WDJ.BUILD_SEQUENCE
, WL.LINE_CODE
, WDJ.LINE_ID
, PJM_PROJECT.ALL_PROJ_IDTONAME(WDJ.PROJECT_ID) PROJECT_NAME
, PJM_PROJECT.ALL_PROJ_IDTONUM(WDJ.PROJECT_ID) PROJECT_NUMBER
, WDJ.PROJECT_ID
, PJM_PROJECT.ALL_TASK_IDTONAME(WDJ.TASK_ID)TASK_NAME
, PJM_PROJECT.ALL_TASK_IDTONUM(WDJ.TASK_ID)TASK_NUMBER
, WDJ.TASK_ID
, WDJ.END_ITEM_UNIT_NUMBER
, WDJ.ATTRIBUTE_CATEGORY
, WDJ.ATTRIBUTE1
, WDJ.ATTRIBUTE2
, WDJ.ATTRIBUTE3
, WDJ.ATTRIBUTE4
, WDJ.ATTRIBUTE5
, WDJ.ATTRIBUTE6
, WDJ.ATTRIBUTE7
, WDJ.ATTRIBUTE8
, WDJ.ATTRIBUTE9
, WDJ.ATTRIBUTE10
, WDJ.ATTRIBUTE11
, WDJ.ATTRIBUTE12
, WDJ.ATTRIBUTE13
, WDJ.ATTRIBUTE14
, WDJ.ATTRIBUTE15
, LU1.MEANING STATUS_TYPE_DISP
, LU2.MEANING WIP_SUPPLY_TYPE_DISP
, WDJ.OVERCOMPLETION_TOLERANCE_TYPE
, WDJ.OVERCOMPLETION_TOLERANCE_VALUE
, WDJ.KANBAN_CARD_ID
, KC.KANBAN_CARD_NUMBER
, WDJ.PO_CREATION_TIME
, WDJ.PRIORITY
, WDJ.DUE_DATE
, WDJ.EST_SCRAP_ACCOUNT
, WDJ.EST_SCRAP_VAR_ACCOUNT
, WE.ENTITY_TYPE
, WDJ.DUE_DATE_PENALTY
, WDJ.DUE_DATE_TOLERANCE
, WDJ.COPRODUCTS_SUPPLY
, WDJ.REQUESTED_START_DATE
, WDJ.SERIALIZATION_START_OP
, WDJ.ACTUAL_START_DATE
, WDJ.EXPECTED_HOLD_RELEASE_DATE
FROM MTL_SECONDARY_INVENTORIES MSUB
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_LINES WL
, WIP_SCHEDULE_GROUPS WSG
, MTL_KANBAN_CARDS KC
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND MSUB.SECONDARY_INVENTORY_NAME (+) = WDJ.COMPLETION_SUBINVENTORY
AND MSUB.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WDJ.SCHEDULE_GROUP_ID
AND WL.LINE_ID (+) = WDJ.LINE_ID
AND WL.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND LU2.LOOKUP_TYPE = 'WIP_SUPPLY'
AND LU1.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LU3.LOOKUP_TYPE = 'WIP_DISCRETE_JOB'
AND LU1.LOOKUP_CODE = WDJ.STATUS_TYPE
AND LU2.LOOKUP_CODE = WDJ.WIP_SUPPLY_TYPE
AND LU3.LOOKUP_CODE = WDJ.JOB_TYPE
AND KC.KANBAN_CARD_ID (+) = WDJ.KANBAN_CARD_ID