VIEW: APPS.PO_ASL_DOCUMENTS_V

Source

View Text - Preformatted

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.CLM_DOCUMENT_NUMBER , PAD.DOCUMENT_LINE_ID , NVL(PL.LINE_NUM_DISPLAY,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'))

View Text - HTML Formatted

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.CLM_DOCUMENT_NUMBER
, PAD.DOCUMENT_LINE_ID
, NVL(PL.LINE_NUM_DISPLAY
, 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'))