VIEW: APPS.PO_RFQS_VAL_V

Source

View Text - Preformatted

SELECT POH.SEGMENT1 , PODT.TYPE_NAME , POH.CREATION_DATE , POH.PO_HEADER_ID , POH.AGENT_ID , POLC.DISPLAYED_FIELD , POH.COMMENTS , PODB.SECURITY_LEVEL_CODE , HRE.FULL_NAME , POH.ORG_ID FROM PO_HEADERS POH, PO_DOCUMENT_TYPES_ALL_TL PODT, PO_DOCUMENT_TYPES_ALL_B PODB, HR_EMPLOYEES_ALL_V HRE, PO_LOOKUP_CODES POLC WHERE POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS' AND POH.STATUS_LOOKUP_CODE = POLC.LOOKUP_CODE AND POH.AGENT_ID = HRE.EMPLOYEE_ID AND POH.TYPE_LOOKUP_CODE = 'RFQ' AND PODB.DOCUMENT_TYPE_CODE = POH.TYPE_LOOKUP_CODE AND PODB.DOCUMENT_SUBTYPE = POH.QUOTATION_CLASS_CODE 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 AND PODB.ORG_ID = POH.ORG_ID AND NVL(POH.CANCEL_FLAG, 'N') IN ('N', 'I') AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('FINALLY CLOSED')

View Text - HTML Formatted

SELECT POH.SEGMENT1
, PODT.TYPE_NAME
, POH.CREATION_DATE
, POH.PO_HEADER_ID
, POH.AGENT_ID
, POLC.DISPLAYED_FIELD
, POH.COMMENTS
, PODB.SECURITY_LEVEL_CODE
, HRE.FULL_NAME
, POH.ORG_ID
FROM PO_HEADERS POH
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, HR_EMPLOYEES_ALL_V HRE
, PO_LOOKUP_CODES POLC
WHERE POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS'
AND POH.STATUS_LOOKUP_CODE = POLC.LOOKUP_CODE
AND POH.AGENT_ID = HRE.EMPLOYEE_ID
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND PODB.DOCUMENT_TYPE_CODE = POH.TYPE_LOOKUP_CODE
AND PODB.DOCUMENT_SUBTYPE = POH.QUOTATION_CLASS_CODE
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
AND PODB.ORG_ID = POH.ORG_ID
AND NVL(POH.CANCEL_FLAG
, 'N') IN ('N'
, 'I')
AND NVL(POH.CLOSED_CODE
, 'OPEN') NOT IN ('FINALLY CLOSED')