Product: | ICX - Oracle iProcurement |
---|---|
Description: | Project Related WIP Job View |
Implementation/DBA Data: | APPS.ICX_EDM_WIP_JOB_V |
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