[Home] [Help]
View: WSM_DISCRETE_JOBS_V
View Text
SELECT WDJ.ROWID ROW_ID
, WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WDJ.STATUS_TYPE
, WDJ.PRIMARY_ITEM_ID
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, LU1.MEANING STATUS_TYPE_DISP
, MSI.DESCRIPTION ASSEMBLY_DESCRIPTION
, WDJ.ORGANIZATION_ID
FROM MTL_SECONDARY_INVENTORIES MSUB
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_LINES WL
, WIP_SCHEDULE_GROUPS WSG
, MTL_KANBAN_CARDS KC
, MTL_SYSTEM_ITEMS MSI
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 LU1.LOOKUP_CODE = WDJ.STATUS_TYPE
AND LU2.LOOKUP_CODE = WDJ.WIP_SUPPLY_TYPE
AND KC.KANBAN_CARD_ID (+) = WDJ.KANBAN_CARD_ID
AND WDJ.PRIMARY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND WDJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
Columns
Name |
ROW_ID |
WIP_ENTITY_ID |
WIP_ENTITY_NAME |
STATUS_TYPE |
PRIMARY_ITEM_ID |
SCHEDULED_START_DATE |
SCHEDULED_COMPLETION_DATE |
STATUS_TYPE_DISP |
ASSEMBLY_DESCRIPTION |
ORGANIZATION_ID |