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'
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'
|
|
|