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: AP_PO_USRDEF_LOOKUP_CODES_V

Product:	AP - Payables
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT FND_AP.APPLICATION_NAME APPLICATION_NAME
, 200 APPLICATION_ID
, LK_AP.LOOKUP_CODE LOOKUP_CODE
, LK_AP.DISPLAYED_FIELD DISPLAYED_FIELD
, LK_AP.DESCRIPTION DESCRIPTION
FROM AP_LOOKUP_CODES LK_AP
, FND_APPLICATION_VL FND_AP
WHERE LK_AP.LOOKUP_TYPE = 'LOOKUP TYPE'
AND FND_AP.APPLICATION_ID = 200 UNION SELECT FND_PO.APPLICATION_NAME APPLICATION_NAME
, 201 APPLICATION_ID
, LK_PO.LOOKUP_CODE LOOKUP_CODE
, LK_PO.DISPLAYED_FIELD DISPLAYED_FIELD
, LK_PO.DESCRIPTION DESCRIPTION
FROM PO_LOOKUP_CODES LK_PO
, FND_APPLICATION_VL FND_PO
WHERE LK_PO.LOOKUP_TYPE = 'LOOKUP TYPE'
AND FND_PO.APPLICATION_ID = 201

Columns

Name
APPLICATION_NAME
APPLICATION_ID
LOOKUP_CODE
DISPLAYED_FIELD
DESCRIPTION