VIEW: APPS.PJM_PROJECT_WIP_COMP_V

Source

View Text - Preformatted

SELECT WRO.ROW_ID , WRO.INVENTORY_ITEM_ID , WRO.CONCATENATED_SEGMENTS , WRO.ITEM_DESCRIPTION , WRO.ITEM_PRIMARY_UOM_CODE , WRO.INVENTORY_ASSET_FLAG , PJM_INQUIRY.LOCATOR_CONTROL( WRO.LOCATION_CONTROL_CODE ) , PJM_INQUIRY.SYS_YES_NO( WRO.RESTRICT_SUBINVENTORIES_CODE ) , PJM_INQUIRY.SYS_YES_NO( WRO.RESTRICT_LOCATORS_CODE ) , WRO.ORGANIZATION_ID , WRO.WIP_ENTITY_ID , WRO.OPERATION_SEQ_NUM , WRO.REPETITIVE_SCHEDULE_ID , WRO.LINE_ID , WRO.LAST_UPDATE_DATE , WRO.LAST_UPDATED_BY , WRO.CREATION_DATE , WRO.CREATED_BY , WRO.LAST_UPDATE_LOGIN , WRO.REQUEST_ID , WRO.PROGRAM_APPLICATION_ID , WRO.PROGRAM_ID , WRO.PROGRAM_UPDATE_DATE , WRO.DEPARTMENT_ID , WRO.DEPARTMENT_CODE , WRO.WIP_SUPPLY_TYPE , WRO.WIP_SUPPLY_MEANING , WRO.DATE_REQUIRED , WRO.REQUIRED_QUANTITY , TO_NUMBER(WRO.QUANTITY_ISSUED) , TO_NUMBER(WRO.QUANTITY_OPEN) , WRO.QUANTITY_PER_ASSEMBLY , WRO.COMMENTS , WRO.SUPPLY_SUBINVENTORY , WRO.SUPPLY_LOCATOR_ID , decode(MP.project_reference_enabled, null,MIL.concatenated_segments, 2,MIL.concatenated_segments, 1, inv_project.get_pjm_locsegs(MIL.concatenated_segments)) , PJM_INQUIRY.SYS_YES_NO( WRO.MRP_NET_FLAG ) , WRO.MPS_REQUIRED_QUANTITY , WRO.MPS_DATE_REQUIRED , PJM_INQUIRY.SYS_YES_NO( WRO.ROUTING_EXISTS_FLAG ) , WRO.FIRST_UNIT_START_DATE , WRO.FIRST_UNIT_COMPLETION_DATE , WRO.LAST_UNIT_COMPLETION_DATE , PJM_INQUIRY.COMPONENT_SERIAL ( WRO.ORGANIZATION_ID , WRO.WIP_ENTITY_ID , WRO.OPERATION_SEQ_NUM , WRO.INVENTORY_ITEM_ID ) FROM WIP_REQUIREMENT_OPERATIONS_V WRO , MTL_ITEM_LOCATIONS_KFV MIL , MTL_PARAMETERS MP WHERE MIL.INVENTORY_LOCATION_ID (+) = WRO.SUPPLY_LOCATOR_ID AND MIL.ORGANIZATION_ID (+) = WRO.ORGANIZATION_ID AND MP.ORGANIZATION_ID = WRO.ORGANIZATION_ID

View Text - HTML Formatted

SELECT WRO.ROW_ID
, WRO.INVENTORY_ITEM_ID
, WRO.CONCATENATED_SEGMENTS
, WRO.ITEM_DESCRIPTION
, WRO.ITEM_PRIMARY_UOM_CODE
, WRO.INVENTORY_ASSET_FLAG
, PJM_INQUIRY.LOCATOR_CONTROL( WRO.LOCATION_CONTROL_CODE )
, PJM_INQUIRY.SYS_YES_NO( WRO.RESTRICT_SUBINVENTORIES_CODE )
, PJM_INQUIRY.SYS_YES_NO( WRO.RESTRICT_LOCATORS_CODE )
, WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.REPETITIVE_SCHEDULE_ID
, WRO.LINE_ID
, WRO.LAST_UPDATE_DATE
, WRO.LAST_UPDATED_BY
, WRO.CREATION_DATE
, WRO.CREATED_BY
, WRO.LAST_UPDATE_LOGIN
, WRO.REQUEST_ID
, WRO.PROGRAM_APPLICATION_ID
, WRO.PROGRAM_ID
, WRO.PROGRAM_UPDATE_DATE
, WRO.DEPARTMENT_ID
, WRO.DEPARTMENT_CODE
, WRO.WIP_SUPPLY_TYPE
, WRO.WIP_SUPPLY_MEANING
, WRO.DATE_REQUIRED
, WRO.REQUIRED_QUANTITY
, TO_NUMBER(WRO.QUANTITY_ISSUED)
, TO_NUMBER(WRO.QUANTITY_OPEN)
, WRO.QUANTITY_PER_ASSEMBLY
, WRO.COMMENTS
, WRO.SUPPLY_SUBINVENTORY
, WRO.SUPPLY_LOCATOR_ID
, DECODE(MP.PROJECT_REFERENCE_ENABLED
, NULL
, MIL.CONCATENATED_SEGMENTS
, 2
, MIL.CONCATENATED_SEGMENTS
, 1
, INV_PROJECT.GET_PJM_LOCSEGS(MIL.CONCATENATED_SEGMENTS))
, PJM_INQUIRY.SYS_YES_NO( WRO.MRP_NET_FLAG )
, WRO.MPS_REQUIRED_QUANTITY
, WRO.MPS_DATE_REQUIRED
, PJM_INQUIRY.SYS_YES_NO( WRO.ROUTING_EXISTS_FLAG )
, WRO.FIRST_UNIT_START_DATE
, WRO.FIRST_UNIT_COMPLETION_DATE
, WRO.LAST_UNIT_COMPLETION_DATE
, PJM_INQUIRY.COMPONENT_SERIAL ( WRO.ORGANIZATION_ID
, WRO.WIP_ENTITY_ID
, WRO.OPERATION_SEQ_NUM
, WRO.INVENTORY_ITEM_ID )
FROM WIP_REQUIREMENT_OPERATIONS_V WRO
, MTL_ITEM_LOCATIONS_KFV MIL
, MTL_PARAMETERS MP
WHERE MIL.INVENTORY_LOCATION_ID (+) = WRO.SUPPLY_LOCATOR_ID
AND MIL.ORGANIZATION_ID (+) = WRO.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = WRO.ORGANIZATION_ID