View: POFV_ASL_DOCUMENTS

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

View Text

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
AND '_SEC:AD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns