FND Design Data [Home] [Help]

View: AP_JE_CATEGORIES_V

Product: AP - Payables
Description:
Implementation/DBA Data: ViewAPPS.AP_JE_CATEGORIES_V
View Text

SELECT JE_CATEGORY_NAME
, USER_JE_CATEGORY_NAME
FROM GL_JE_CATEGORIES
WHERE JE_CATEGORY_NAME IN ( 'PAYMENTS'
, 'PURCHASE INVOICES'
, 'RECONCILED PAYMENTS') UNION SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BOTH_ALL_NONE'
AND LOOKUP_CODE = 'A'

Columns

Name
JE_CATEGORY_NAME
USER_JE_CATEGORY_NAME