View: PO_ASL_DOCUMENTS_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_ASL_DOCUMENTS_V

View Text

SELECT PAD.ROWID
, PAD.ASL_ID
, PAD.USING_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOUT.NAME
, PAD.SEQUENCE_NUM
, PAD.DOCUMENT_TYPE_CODE
, POLC.DISPLAYED_FIELD
, PAD.DOCUMENT_HEADER_ID
, PH.SEGMENT1
, PAD.DOCUMENT_LINE_ID
, PL.LINE_NUM
, PH.START_DATE
, PH.END_DATE
, DECODE(PAD.DOCUMENT_TYPE_CODE
, 'QUOTATION'
, PH.STATUS_LOOKUP_CODE
, 'BLANKET'
, PH.AUTHORIZATION_STATUS
, 'CONTRACT'
, PH.AUTHORIZATION_STATUS)
, PLC.DISPLAYED_FIELD
, PASL.VENDOR_ID
, PASL.VENDOR_SITE_ID
, PASL.ITEM_ID
, PASL.CATEGORY_ID
, PAD.ATTRIBUTE_CATEGORY
, PAD.ATTRIBUTE1
, PAD.ATTRIBUTE2
, PAD.ATTRIBUTE3
, PAD.ATTRIBUTE4
, PAD.ATTRIBUTE5
, PAD.ATTRIBUTE6
, PAD.ATTRIBUTE7
, PAD.ATTRIBUTE8
, PAD.ATTRIBUTE9
, PAD.ATTRIBUTE10
, PAD.ATTRIBUTE11
, PAD.ATTRIBUTE12
, PAD.ATTRIBUTE13
, PAD.ATTRIBUTE14
, PAD.ATTRIBUTE15
, PAD.LAST_UPDATE_LOGIN
, PAD.REQUEST_ID
, PAD.PROGRAM_APPLICATION_ID
, PAD.PROGRAM_ID
, PAD.PROGRAM_UPDATE_DATE
, PAD.LAST_UPDATE_DATE
, PAD.LAST_UPDATED_BY
, PAD.CREATION_DATE
, PAD.CREATED_BY
, PH.ORG_ID
FROM PO_LOOKUP_CODES POLC
, HR_ORG_UNITS_NO_JOIN HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, PO_LOOKUP_CODES PLC
, MTL_PARAMETERS MP
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_APPROVED_SUPPLIER_LIST PASL
, PO_ASL_DOCUMENTS PAD
WHERE PAD.DOCUMENT_HEADER_ID = PH.PO_HEADER_ID
AND PAD.DOCUMENT_LINE_ID = PL.PO_LINE_ID (+)
AND DECODE(PH.TYPE_LOOKUP_CODE
, 'QUOTATION'
, PH.STATUS_LOOKUP_CODE
, 'BLANKET'
, PH.AUTHORIZATION_STATUS
, 'CONTRACT'
, PH.AUTHORIZATION_STATUS) = PLC.LOOKUP_CODE(+)
AND DECODE(PH.TYPE_LOOKUP_CODE
, 'QUOTATION'
, 'RFQ/QUOTE STATUS'
, 'BLANKET'
, 'AUTHORIZATION STATUS'
, 'CONTRACT'
, 'AUTHORIZATION STATUS') = PLC.LOOKUP_TYPE(+)
AND PAD.USING_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND PAD.USING_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND PASL.ASL_ID = PAD.ASL_ID
AND POLC.LOOKUP_TYPE = 'PO TYPE'
AND POLC.LOOKUP_CODE = PAD.DOCUMENT_TYPE_CODE AND HOU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID (+)
AND DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, HOUT.LANGUAGE) = DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))

Columns