VIEW: APPS.ICX_EDM_WIP_JOB_V

Source

View Text - Preformatted

SELECT DISTINCT WDJ.PROJECT_ID , WDJ.TASK_ID , MRP_GET_PROJECT.PROJECT(WDJ.PROJECT_ID) , MRP_GET_PROJECT.TASK(WDJ.TASK_ID) , WE.WIP_ENTITY_NAME WIP_JOB_NAME , WDJ.DESCRIPTION , WDJ.CLASS_CODE , MLC.MEANING WIP_JOB_STATUS , WDJ.BOM_REVISION , WDJ.ALTERNATE_BOM_DESIGNATOR , PARA.ORGANIZATION_CODE , ORG.NAME ORGANIZATION_NAME , ITEMKFV.CONCATENATED_SEGMENTS ASSEMBLY , ITEMKFV.DESCRIPTION ASSEMBLY_DESCRIPTION , ITEMKFV.PRIMARY_UOM_CODE , WDJ.SCHEDULED_START_DATE , WDJ.START_QUANTITY , WDJ.SCHEDULED_COMPLETION_DATE , NVL(WDJ.QUANTITY_COMPLETED, 0) QUANTITY_COMPLETED , NVL(WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED, 0) QUANTITY_REMAINING , NVL(WDJ.QUANTITY_SCRAPPED, 0) QUANTITY_SCRAPPED , WDJ.WIP_ENTITY_ID WIP_JOB_ID , WDJ.ORGANIZATION_ID , WDJ.PRIMARY_ITEM_ID , WDJ.COMMON_BOM_SEQUENCE_ID FROM WIP_ENTITIES WE , WIP_DISCRETE_JOBS WDJ , HR_ORGANIZATION_UNITS ORG , MTL_PARAMETERS PARA , MTL_SYSTEM_ITEMS_KFV ITEMKFV , MFG_LOOKUPS MLC WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND ORG.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND PARA.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND ITEMKFV.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID AND ITEMKFV.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND MLC.LOOKUP_TYPE(+) = 'WIP_JOB_STATUS' AND MLC.LOOKUP_CODE(+) = WDJ.STATUS_TYPE

View Text - HTML Formatted

SELECT DISTINCT WDJ.PROJECT_ID
, WDJ.TASK_ID
, MRP_GET_PROJECT.PROJECT(WDJ.PROJECT_ID)
, MRP_GET_PROJECT.TASK(WDJ.TASK_ID)
, WE.WIP_ENTITY_NAME WIP_JOB_NAME
, WDJ.DESCRIPTION
, WDJ.CLASS_CODE
, MLC.MEANING WIP_JOB_STATUS
, WDJ.BOM_REVISION
, WDJ.ALTERNATE_BOM_DESIGNATOR
, PARA.ORGANIZATION_CODE
, ORG.NAME ORGANIZATION_NAME
, ITEMKFV.CONCATENATED_SEGMENTS ASSEMBLY
, ITEMKFV.DESCRIPTION ASSEMBLY_DESCRIPTION
, ITEMKFV.PRIMARY_UOM_CODE
, WDJ.SCHEDULED_START_DATE
, WDJ.START_QUANTITY
, WDJ.SCHEDULED_COMPLETION_DATE
, NVL(WDJ.QUANTITY_COMPLETED
, 0) QUANTITY_COMPLETED
, NVL(WDJ.START_QUANTITY - WDJ.QUANTITY_COMPLETED - WDJ.QUANTITY_SCRAPPED
, 0) QUANTITY_REMAINING
, NVL(WDJ.QUANTITY_SCRAPPED
, 0) QUANTITY_SCRAPPED
, WDJ.WIP_ENTITY_ID WIP_JOB_ID
, WDJ.ORGANIZATION_ID
, WDJ.PRIMARY_ITEM_ID
, WDJ.COMMON_BOM_SEQUENCE_ID
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, HR_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS PARA
, MTL_SYSTEM_ITEMS_KFV ITEMKFV
, MFG_LOOKUPS MLC
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND ORG.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND PARA.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND ITEMKFV.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND ITEMKFV.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND MLC.LOOKUP_TYPE(+) = 'WIP_JOB_STATUS'
AND MLC.LOOKUP_CODE(+) = WDJ.STATUS_TYPE