View: WIP_ON_DISCRETE_JOBS_V

Product:	WIP - Work in Process
Description:	AK Job Composition View
Implementation/DBA Data:	APPS.WIP_ON_DISCRETE_JOBS_V

View Text

SELECT WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WDJ.ORGANIZATION_ID
, WDJ.PRIMARY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, WDJ.START_QUANTITY
, WDJ.LOT_NUMBER
, WDJ.QUANTITY_COMPLETED
FROM WIP_ENTITIES WE
, MTL_SYSTEM_ITEMS_KFV MSIK
, WIP_DISCRETE_JOBS WDJ
WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WDJ.ORGANIZATION_ID

Columns