[Home] [Help]
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
Name |
REPORT_HEADER_ID |
TRX_DATE |
CURRENCY_CODE |
EXCHANGE_RATE |
EXCHANGE_DATE |
PROJECT_ID |
EXPENDITURE_ITEM_DATE |
ORG_ID |
SET_OF_BOOKS_ID |
AMOUNT |
BASE_AMOUNT |
ON_HOLD |
SOURCE |
INVOICE_NUM |
REFERENCE_ID |