View: CST_WIP_ENTITY_VIEW

Product:	BOM - Bills of Material
Description:	WIP entity information used by the WIP Value inquiry : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_WIP_ENTITY_VIEW

View Text

SELECT E.WIP_ENTITY_ID
, E.ORGANIZATION_ID
, E.WIP_ENTITY_NAME
, E.DESCRIPTION
, E.ENTITY_TYPE
, -1
, NULL
, J.PRIMARY_ITEM_ID
, J.CLASS_CODE
FROM WIP_ENTITIES E
, WIP_DISCRETE_JOBS J
WHERE E.WIP_ENTITY_ID = J.WIP_ENTITY_ID UNION SELECT E.WIP_ENTITY_ID
, E.ORGANIZATION_ID
, E.WIP_ENTITY_NAME
, E.DESCRIPTION
, E.ENTITY_TYPE
, L.LINE_ID
, L.LINE_CODE
, R.PRIMARY_ITEM_ID
, R.CLASS_CODE
FROM WIP_ENTITIES E
, WIP_LINES L
, WIP_REPETITIVE_ITEMS R
WHERE E.WIP_ENTITY_ID = R.WIP_ENTITY_ID
AND R.LINE_ID = L.LINE_ID

Columns