[Home] [Help]
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
Name |
WIP_ENTITY_ID |
ORGANIZATION_ID |
WIP_ENTITY_NAME |
ENTITY_DESCRIPTION |
ENTITY_TYPE |
LINE_ID |
LINE_CODE |
PRIMARY_ITEM_ID |
CLASS_CODE |