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

VIEW: APPS.CE_AR_FC_INVOICES_V

Object Details
Object Name: CE_AR_FC_INVOICES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_AR_FC_INVOICES_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_INVOICES_V view contains AR invoices for forecasting. The Cash Forecasting program uses this view to generate projected cash inflow amounts from the AR invoices. When determining forecast amounts, the program selects only the applicable invoices from this view that match the forecast template definition and forecast submission parameters.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRX_NUMBER VARCHAR2 (30)
Invoice number
BASE_AMOUNT NUMBER

Invoice amount in the functional currency
AMOUNT NUMBER

Invoice amount
DISPUTE_AMOUNT NUMBER

Portion of invoice amounts that are in dispute
CURRENCY_CODE VARCHAR2 (15)
Currency code of the invoice
EXCHANGE_RATE NUMBER

Currency exchange rate for the foreign currency invoice
TRX_DATE DATE

Receipt due date
PROFILE_CLASS_ID NUMBER (15)
Profile class assigned to the invoice
CUSTOMER_TRX_ID NUMBER (15)
Invoice identifier
ORG_ID NUMBER (15)
Organization identifier
CUSTOMER_ID NUMBER (15)
Customer identifier
SITE_USE_ID NUMBER (15)
Identifies the customer site associated with the customer
INVOICE_DATE DATE

Transaction date of item
PROFILE_CLASS VARCHAR2 (30)
Profile Class
REFERENCE_ID VARCHAR2 (42)
Reference identifier
Query Text

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


SELECT TRX_NUMBER
,      BASE_AMOUNT
,      AMOUNT
,      DISPUTE_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      TRX_DATE
,      PROFILE_CLASS_ID
,      CUSTOMER_TRX_ID
,      ORG_ID
,      CUSTOMER_ID
,      SITE_USE_ID
,      INVOICE_DATE
,      PROFILE_CLASS
,      REFERENCE_ID
FROM APPS.CE_AR_FC_INVOICES_V;

Dependencies

[top of page]

APPS.CE_AR_FC_INVOICES_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
PL/SQL PackageAR_PUBLIC_UTILS - show dependent code
SynonymHZ_CUSTOMER_PROFILES
SynonymHZ_CUST_PROFILE_CLASSES
APPS.CE_AR_FC_INVOICES_V is referenced by following:

SchemaAPPS
ViewCE_FC_ARI_DISC_V