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.PJM_PROJECT_WIP_V

Source

View Text - Preformatted


SELECT DISTINCT WDJ.PROJECT_ID , WDJ.TASK_ID , WDJ.WIP_ENTITY_ID , WE.WIP_ENTITY_NAME , WDJ.DESCRIPTION , WDJ.CLASS_CODE , MLC.MEANING , HOU.NAME , ITEMKFV.CONCATENATED_SEGMENTS , ITEMKFV.DESCRIPTION , WDJ.PRIMARY_ITEM_ID , WDJ.END_ITEM_UNIT_NUMBER , WDJ.SCHEDULED_START_DATE , WDJ.SCHEDULED_COMPLETION_DATE , WDJ.START_QUANTITY , ITEMKFV.PRIMARY_UOM_CODE , NVL( WDJ.QUANTITY_COMPLETED , 0 ) , NVL( WDJ.START_QUANTITY , 0 ) - NVL( WDJ.QUANTITY_COMPLETED , 0 ) - NVL( WDJ.QUANTITY_SCRAPPED , 0) , NVL(WDJ.QUANTITY_SCRAPPED , 0) , WDJ.BOM_REFERENCE_ID , WDJ.BOM_REVISION , WDJ.ROUTING_REFERENCE_ID FROM WIP_ENTITIES WE , WIP_DISCRETE_JOBS WDJ , MTL_PARAMETERS PARA , MTL_SYSTEM_ITEMS_KFV ITEMKFV , MFG_LOOKUPS MLC , HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND PARA.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND ITEMKFV.INVENTORY_ITEM_ID (+) = WDJ.PRIMARY_ITEM_ID AND ITEMKFV.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID AND MLC.LOOKUP_TYPE (+) = 'WIP_JOB_STATUS' AND MLC.LOOKUP_CODE (+) = WDJ.STATUS_TYPE AND HOU.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT DISTINCT WDJ.PROJECT_ID
, WDJ.TASK_ID
, WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WDJ.DESCRIPTION
, WDJ.CLASS_CODE
, MLC.MEANING
, HOU.NAME
, ITEMKFV.CONCATENATED_SEGMENTS
, ITEMKFV.DESCRIPTION
, WDJ.PRIMARY_ITEM_ID
, WDJ.END_ITEM_UNIT_NUMBER
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.START_QUANTITY
, ITEMKFV.PRIMARY_UOM_CODE
, NVL( WDJ.QUANTITY_COMPLETED
, 0 )
, NVL( WDJ.START_QUANTITY
, 0 ) - NVL( WDJ.QUANTITY_COMPLETED
, 0 ) - NVL( WDJ.QUANTITY_SCRAPPED
, 0)
, NVL(WDJ.QUANTITY_SCRAPPED
, 0)
, WDJ.BOM_REFERENCE_ID
, WDJ.BOM_REVISION
, WDJ.ROUTING_REFERENCE_ID
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, MTL_PARAMETERS PARA
, MTL_SYSTEM_ITEMS_KFV ITEMKFV
, MFG_LOOKUPS MLC
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND PARA.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND ITEMKFV.INVENTORY_ITEM_ID (+) = WDJ.PRIMARY_ITEM_ID
AND ITEMKFV.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND MLC.LOOKUP_TYPE (+) = 'WIP_JOB_STATUS'
AND MLC.LOOKUP_CODE (+) = WDJ.STATUS_TYPE
AND HOU.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')