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

VIEW: APPS.CE_AR_FC_RECEIPTS_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


The CE_AR_FC_RECEIPTS_V view contains AR receipts for forecasting. The Cash Forecasting program uses this view to generate projected forecast inflow amounts from the AR receipts. When determining forecast amounts, the program selects only the applicable receipts from this view that match the forecast template definition and forecast submission parameters. For example, when forecasting based on historical data, the Cash Forecasting program selects only the receipts that were previously cleared or reconciled. Similarly, when forecasting by future method, the program selects only the receipts that are remitted but not yet cleared.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BASE_AMOUNT NUMBER

Receipt amount in the functional currency
AMOUNT NUMBER

Receipt amount
CURRENCY_CODE VARCHAR2 (15)
Currency code of the receipt
TRX_DATE DATE

Transaction date
MATURITY_DATE DATE

Receipt due date
ACTUAL_VALUE_DATE DATE

Actual value date
BANK_ACCOUNT_ID NUMBER

Bank account identifier
RECEIPT_METHOD_ID NUMBER (15)
Receipt method identifier
STATUS VARCHAR2 (30)
Receipt status
EFFECTIVE_DATE DATE

Cleared or anticipated cleared date
ORG_ID NUMBER (15)
Organization identifier
RECEIPT_NUMBER VARCHAR2 (30)
Receipt Number
REFERENCE_ID NUMBER (15)
Reference identifier
CASH_ACTIVITY_DATE DATE

Cash activity date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BASE_AMOUNT
,      AMOUNT
,      CURRENCY_CODE
,      TRX_DATE
,      MATURITY_DATE
,      ACTUAL_VALUE_DATE
,      BANK_ACCOUNT_ID
,      RECEIPT_METHOD_ID
,      STATUS
,      EFFECTIVE_DATE
,      ORG_ID
,      RECEIPT_NUMBER
,      REFERENCE_ID
,      CASH_ACTIVITY_DATE
FROM APPS.CE_AR_FC_RECEIPTS_V;

Dependencies

[top of page]

APPS.CE_AR_FC_RECEIPTS_V references the following:

SchemaAPPS
PL/SQL PackageARP_CASHBOOK - show dependent code
SynonymAR_CASH_RECEIPTS_ALL
SynonymAR_CASH_RECEIPT_HISTORY_ALL
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymCE_BANK_ACCOUNTS
SynonymCE_BANK_ACCT_USES_ALL
APPS.CE_AR_FC_RECEIPTS_V is referenced by following:

SchemaAPPS
ViewCE_CP_DISC_ARR_V
ViewCE_CP_DISC_OVERDUE_V
ViewCE_CP_DISC_PRIOR_V
Package BodyCE_CP_PRIORDAY - show dependent code
Package BodyCE_CSH_FCST_POP - show dependent code
ViewCE_FC_ARR_DISC_V