View: POR_RCV_HOME_REQS_V

Product:	ICX - Oracle iProcurement
Description:	View to query requisitions in receiving home page
Implementation/DBA Data:	APPS.POR_RCV_HOME_REQS_V

View Text

SELECT PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRH.DESCRIPTION
, PRH.PREPARER_ID
, PRL.TO_PERSON_ID
, POH.SEGMENT1 ORDER_NUM
, POV.VENDOR_NAME VENDOR
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_LINE_LOCATIONS PLL
, PO_HEADERS POH
, PO_DISTRIBUTIONS POD
, PO_VENDORS POV
WHERE NVL(PLL.APPROVED_FLAG
, 'N') = 'Y'
AND NVL(PLL.CANCEL_FLAG
, 'N') = 'N'
AND NVL(PLL.CLOSED_CODE
, 'OPEN') NOT IN ('FINALLY CLOSED'
, 'CLOSED'
, 'CLOSED FOR RECEIVING')
AND PLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND PLL.RECEIVING_ROUTING_ID = 3
AND (POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_DELIVERED
, 0) - NVL(POD.QUANTITY_CANCELLED
, 0)) > 0
AND POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND POH.VENDOR_ID = POV.VENDOR_ID UNION ALL SELECT PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRH.DESCRIPTION
, PRH.PREPARER_ID
, PRL.TO_PERSON_ID
, PO_INQ_SV.GET_SO_NUMBER(TO_CHAR(PRH.REQUISITION_HEADER_ID)
, PRL.REQUISITION_LINE_ID)
, HAOU.NAME
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, RCV_SHIPMENT_LINES RSL
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND RSL.ROUTING_HEADER_ID = 3
AND RSL.QUANTITY_SHIPPED > NVL(RSL.QUANTITY_RECEIVED
, 0)
AND PRL.SOURCE_TYPE_CODE='INVENTORY'
AND HAOU.ORGANIZATION_ID = PRL.SOURCE_ORGANIZATION_ID

Columns