VIEW: APPS.POFV_ASL_DOCUMENTS

Source

View Text - Preformatted

SELECT ad.ASL_ID, ad.USING_ORGANIZATION_ID, uc.ORGANIZATION_CODE, uo.NAME, ph.ORG_ID, op.NAME, ad.SEQUENCE_NUM, '_LA:ad.DOCUMENT_TYPE_CODE:PO_LOOKUP_CODES:PO TYPE:DISPLAYED_FIELD', '_DF:PO:PO_ASL_DOCUMENTS:ad', ad.DOCUMENT_HEADER_ID, ph.SEGMENT1, ad.DOCUMENT_LINE_ID, pl.LINE_NUM, ad.CREATION_DATE, ad.CREATED_BY, ad.LAST_UPDATE_DATE, ad.LAST_UPDATED_BY FROM PO_ASL_DOCUMENTS AD, PO_APPROVED_SUPPLIER_LIST AL, HR_ALL_ORGANIZATION_UNITS UO, MTL_PARAMETERS UC, HR_ALL_ORGANIZATION_UNITS OP, PO_HEADERS_ALL PH, PO_LINES_ALL PL WHERE AD.ASL_ID = AL.ASL_ID AND AD.USING_ORGANIZATION_ID = AL.USING_ORGANIZATION_ID AND AD.USING_ORGANIZATION_ID = UC.ORGANIZATION_ID(+) AND AD.USING_ORGANIZATION_ID = UO.ORGANIZATION_ID(+) AND PH.ORG_ID = OP.ORGANIZATION_ID(+) AND AD.DOCUMENT_HEADER_ID = PH.PO_HEADER_ID AND AD.DOCUMENT_LINE_ID = PL.PO_LINE_ID WITH READ ONLY

View Text - HTML Formatted

SELECT AD.ASL_ID
, AD.USING_ORGANIZATION_ID
, UC.ORGANIZATION_CODE
, UO.NAME
, PH.ORG_ID
, OP.NAME
, AD.SEQUENCE_NUM
, '_LA:AD.DOCUMENT_TYPE_CODE:PO_LOOKUP_CODES:PO TYPE:DISPLAYED_FIELD'
, '_DF:PO:PO_ASL_DOCUMENTS:AD'
, AD.DOCUMENT_HEADER_ID
, PH.SEGMENT1
, AD.DOCUMENT_LINE_ID
, PL.LINE_NUM
, AD.CREATION_DATE
, AD.CREATED_BY
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
FROM PO_ASL_DOCUMENTS AD
, PO_APPROVED_SUPPLIER_LIST AL
, HR_ALL_ORGANIZATION_UNITS UO
, MTL_PARAMETERS UC
, HR_ALL_ORGANIZATION_UNITS OP
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
WHERE AD.ASL_ID = AL.ASL_ID
AND AD.USING_ORGANIZATION_ID = AL.USING_ORGANIZATION_ID
AND AD.USING_ORGANIZATION_ID = UC.ORGANIZATION_ID(+)
AND AD.USING_ORGANIZATION_ID = UO.ORGANIZATION_ID(+)
AND PH.ORG_ID = OP.ORGANIZATION_ID(+)
AND AD.DOCUMENT_HEADER_ID = PH.PO_HEADER_ID
AND AD.DOCUMENT_LINE_ID = PL.PO_LINE_ID WITH READ ONLY