eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: POBV_ASL_DOCUMENTS

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

View Text

SELECT AD.ASL_ID
, AD.USING_ORGANIZATION_ID
, AD.ORG_ID
, AD.SEQUENCE_NUM
, '_LA:AD.DOCUMENT_TYPE_CODE:PO_LOOKUP_CODES:PO TYPE:DISPLAYED_FIELD'
, AD.DOCUMENT_HEADER_ID
, AD.DOCUMENT_LINE_ID
, AD.CREATION_DATE
, AD.CREATED_BY
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
FROM PO_ASL_DOCUMENTS AD
WHERE '_SEC:AD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
APPROVED_SUPPLIER_LIST_ID
USING_ORGANIZATION_ID
OPERATING_UNIT_ID
SEQUENCE_NUMBER
"_LA:DOCUMENT_TYPE"
DOCUMENT_ID
DOCUMENT_LINE_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY