View: PO_REQS_IN_TRANSIT_ALL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_REQS_IN_TRANSIT_ALL_V

View Text

SELECT DISTINCT PRH.SEGMENT1
, PRH.REQUISITION_HEADER_ID
, PRH.TYPE_LOOKUP_CODE
, PRH.PREPARER_ID
, HRE.FULL_NAME
, POLC.DISPLAYED_FIELD
, PRH.DESCRIPTION
, PODB.SECURITY_LEVEL_CODE
, PRH.ORG_ID
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES_ALL PRL
, HR_EMPLOYEES HRE
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_LOOKUP_CODES POLC
, RCV_SHIPMENT_LINES RSL
WHERE PRL.TO_PERSON_ID = HRE.EMPLOYEE_ID
AND PODB.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODB.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PODB.ORG_ID = PRH.ORG_ID
AND POLC.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID

Columns