VIEW: APPS.CST_WIP_ENTITY_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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