VIEW: APPS.AP_WEB_EXP_TYPE_ITEM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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