DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CE_AP_FC_EXP_REPORTS_V

Object Details
Object Name: CE_AP_FC_EXP_REPORTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_AP_FC_EXP_REPORTS_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.CE_AP_FC_EXP_REPORTS_V references the following:

SchemaAPPS
SynonymAP_EXPENSE_REPORT_HEADERS_ALL
SynonymAP_EXPENSE_REPORT_LINES_ALL

APPS.CE_AP_FC_EXP_REPORTS_V is not referenced by any database object