VIEW: APPS.PO_REQS_IN_TRANSIT_ALL_V

Source

View Text - Preformatted

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 POLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS' 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

View Text - HTML Formatted

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 POLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
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