eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSM_DISCRETE_JOBS_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)