VIEW: APPS.CST_WIP_ENTITY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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