View: CE_AP_FC_EXP_REPORTS_V

Product:	CE - Cash Management
Description:	Forecasting source - AP Expense Reports
Implementation/DBA Data:	APPS.CE_AP_FC_EXP_REPORTS_V

View Text

SELECT H.REPORT_HEADER_ID
, H.WEEK_END_DATE
, L.CURRENCY_CODE
, L.EXCHANGE_RATE
, L.EXCHANGE_DATE
, L.PROJECT_ID
, L.EXPENDITURE_ITEM_DATE
, L.ORG_ID
, L.SET_OF_BOOKS_ID
, NVL(L.AMOUNT
, 0)
, NVL(L.AMOUNT
, 0)*NVL(L.EXCHANGE_RATE
, 1)
, DECODE(H.HOLD_LOOKUP_CODE
, NULL
, 'N'
, 'Y')
, H.SOURCE
, H.INVOICE_NUM
, 'AP' || H.REPORT_HEADER_ID
FROM AP_EXPENSE_REPORT_HEADERS_ALL H
, AP_EXPENSE_REPORT_LINES_ALL L
WHERE H.REPORT_HEADER_ID = L.REPORT_HEADER_ID
AND (H.ORG_ID = L.ORG_ID OR H.ORG_ID IS NULL)
AND VOUCHNO = 0

Columns