[Home] [Help]
View: 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
Name |
SEGMENT1 |
REQUISITION_HEADER_ID |
TYPE_LOOKUP_CODE |
PREPARER_ID |
FULL_NAME |
DISPLAYED_FIELD |
DESCRIPTION |
SECURITY_LEVEL_CODE |
ORG_ID |