View: PJM_PROJECT_WIP_V

Product:	PJM - Project Manufacturing
Description:	Project related WIP job information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_WIP_V

View Text

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')

Columns