View: CST_WIP_ENTITY_V

Product:	BOM - Bills of Material
Description:	Job or schedule information : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_WIP_ENTITY_V

View Text

SELECT E.WIP_ENTITY_ID
, E.ORGANIZATION_ID
, E.WIP_ENTITY_NAME
, E.DESCRIPTION
, E.ENTITY_TYPE
, LU2.MEANING
, -1
, NULL
, J.PRIMARY_ITEM_ID
, J.CLASS_CODE
, J.BOM_REVISION
, J.STATUS_TYPE
, LU.MEANING
, MSI.PRIMARY_UOM_CODE
, J.DATE_CLOSED
, J.ROWID
, J.LAST_UPDATE_DATE
, J.LAST_UPDATED_BY
, J.CREATION_DATE
, J.CREATED_BY
, J.LAST_UPDATE_LOGIN
, J.REQUEST_ID
, J.PROGRAM_APPLICATION_ID
, J.PROGRAM_ID
, J.PROGRAM_UPDATE_DATE
FROM MFG_LOOKUPS LU
, MFG_LOOKUPS LU2
, MTL_SYSTEM_ITEMS_VL MSI
, WIP_DISCRETE_JOBS J
, WIP_ENTITIES E
WHERE J.WIP_ENTITY_ID = E.WIP_ENTITY_ID
AND J.ORGANIZATION_ID = E.ORGANIZATION_ID
AND LU.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LU.LOOKUP_CODE = J.STATUS_TYPE
AND J.PRIMARY_ITEM_ID IS NOT NULL
AND MSI.INVENTORY_ITEM_ID = J.PRIMARY_ITEM_ID
AND MSI.ORGANIZATION_ID = E.ORGANIZATION_ID
AND LU2.LOOKUP_TYPE = 'WIP_ENTITY'
AND LU2.LOOKUP_CODE = E.ENTITY_TYPE
AND J.FIRM_PLANNED_FLAG IN (1
, 2) UNION ALL SELECT E.WIP_ENTITY_ID
, E.ORGANIZATION_ID
, E.WIP_ENTITY_NAME
, E.DESCRIPTION
, E.ENTITY_TYPE
, LU2.MEANING
, -1
, NULL
, J.PRIMARY_ITEM_ID
, J.CLASS_CODE
, J.BOM_REVISION
, J.STATUS_TYPE
, LU.MEANING
, NULL
, J.DATE_CLOSED
, J.ROWID
, J.LAST_UPDATE_DATE
, J.LAST_UPDATED_BY
, J.CREATION_DATE
, J.CREATED_BY
, J.LAST_UPDATE_LOGIN
, J.REQUEST_ID
, J.PROGRAM_APPLICATION_ID
, J.PROGRAM_ID
, J.PROGRAM_UPDATE_DATE
FROM MFG_LOOKUPS LU
, MFG_LOOKUPS LU2
, WIP_DISCRETE_JOBS J
, WIP_ENTITIES E
WHERE J.WIP_ENTITY_ID = E.WIP_ENTITY_ID
AND J.ORGANIZATION_ID = E.ORGANIZATION_ID
AND LU.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LU.LOOKUP_CODE = J.STATUS_TYPE
AND J.PRIMARY_ITEM_ID IS NULL
AND LU2.LOOKUP_TYPE = 'WIP_ENTITY'
AND LU2.LOOKUP_CODE = E.ENTITY_TYPE
AND J.FIRM_PLANNED_FLAG IN (1
, 2) UNION ALL SELECT R.WIP_ENTITY_ID
, R.ORGANIZATION_ID
, ''
, MSI.DESCRIPTION
, /* ENTITY_TYPE */ 2
, LU2.MEANING
, R.LINE_ID
, L.LINE_CODE
, R.PRIMARY_ITEM_ID
, R.CLASS_CODE
, NULL
, /* REV */ -1
, /* STATUS_TYPE */ ''
, /* DESC */ MSI.PRIMARY_UOM_CODE
, SYSDATE
, R.ROWID
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.REQUEST_ID
, R.PROGRAM_APPLICATION_ID
, R.PROGRAM_ID
, R.PROGRAM_UPDATE_DATE
FROM MFG_LOOKUPS LU2
, MTL_SYSTEM_ITEMS_VL MSI
, WIP_LINES L
, WIP_REPETITIVE_ITEMS R
, WIP_REPETITIVE_SCHEDULES J
WHERE L.LINE_ID = R.LINE_ID
AND J.WIP_ENTITY_ID = R.WIP_ENTITY_ID
AND J.LINE_ID = R.LINE_ID
AND L.ORGANIZATION_ID = R.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = R.PRIMARY_ITEM_ID
AND MSI.ORGANIZATION_ID = R.ORGANIZATION_ID
AND LU2.LOOKUP_TYPE = 'WIP_ENTITY'
AND LU2.LOOKUP_CODE = 2 GROUP BY R.WIP_ENTITY_ID
, R.ORGANIZATION_ID
, MSI.DESCRIPTION
, LU2.MEANING
, R.LINE_ID
, L.LINE_CODE
, R.PRIMARY_ITEM_ID
, R.CLASS_CODE
, MSI.PRIMARY_UOM_CODE
, R.ROWID
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.REQUEST_ID
, R.PROGRAM_APPLICATION_ID
, R.PROGRAM_ID
, R.PROGRAM_UPDATE_DATE

Columns