[Home] [Help] [Dependency Information]
Object Name: | CE_AP_FC_EXP_REPORTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_AP_FC_EXP_REPORTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains AP Expense Reports for Cash Forecasting. The Cash Forecasting program then uses this view to generate projected cashflow amounts from AP Expense Reports. Based on the forecast template definition and forecast submission criteria, the Cash Forecasting program determines forecast amounts by selecting only the applicable expense reports from this view.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_HEADER_ID | NUMBER | Yes | Expense report header identifier | |
TRX_DATE | DATE | Yes | Period Ending date of expense report | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
EXCHANGE_RATE | NUMBER | Exchange rate for foreign currency | ||
EXCHANGE_DATE | DATE | Date exchange rate is effective | ||
PROJECT_ID | NUMBER | (15) | Project ID for Oracle Project Accounting expense report line | |
EXPENDITURE_ITEM_DATE | DATE | Item date for Oracle Project Accounting expense report line | ||
ORG_ID | NUMBER | (15) | Organization ID | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
AMOUNT | NUMBER | Amount | ||
BASE_AMOUNT | NUMBER | Amount in functional currency | ||
ON_HOLD | VARCHAR2 | (1) | Hold placed on expense report | |
SOURCE | VARCHAR2 | (25) | Source of expense report | |
INVOICE_NUM | VARCHAR2 | (50) | Invoice Number | |
REFERENCE_ID | VARCHAR2 | (42) | Reference identifier |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.CE_AP_FC_EXP_REPORTS_V;
APPS.CE_AP_FC_EXP_REPORTS_V is not referenced by any database object
|
|
|