View: PJM_PROJECT_WIP_COMP_V

Product:	PJM - Project Manufacturing
Description:	WIP job component information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_WIP_COMP_V

View Text

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
, 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
WHERE MIL.INVENTORY_LOCATION_ID (+) = WRO.SUPPLY_LOCATOR_ID
AND MIL.ORGANIZATION_ID (+) = WRO.ORGANIZATION_ID

Columns