View: AP_WEB_EXP_TYPE_ITEM_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_WEB_EXP_TYPE_ITEM_V

View Text

SELECT PARAMETER_ID
, EXPENSE_REPORT_ID
, PROMPT
, END_DATE
, AP_WEB_EXP_ITEM_UTIL.ITEMIZATION_ALLOWED(PARAMETER_ID)
, WEB_ENABLED_FLAG
FROM AP_EXPENSE_REPORT_PARAMS
WHERE CATEGORY_CODE NOT IN ('PER_DIEM'
, 'MILEAGE') UNION SELECT PARAMETER_ID
, AP_WEB_EXP_ITEM_UTIL.GET_REP_ID
, PROMPT
, END_DATE
, AP_WEB_EXP_ITEM_UTIL.ITEMIZATION_ALLOWED(PARAMETER_ID)
, WEB_ENABLED_FLAG
FROM AP_EXPENSE_REPORT_PARAMS
WHERE WEB_ENABLED_FLAG = 'Y'
AND CATEGORY_CODE NOT IN ('PER_DIEM'
, 'MILEAGE')

Columns