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

VIEW: APPS.CE_AP_FC_DISC_INVOICES_V

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

View Type

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


The CE_AP_FC_DISC_INVOICES_V view contains unpaid AP invoices and their discount information for forecasting. The Cash Forecasting program then uses the CE_DISC_INVOICES_V view, which is based on this view, to generate projected cash outflow amounts from the AP invoices. Based on the forecast template source definition, the CE_DISC_INVOICES_V view determines which discount to use when calculating the projected cash flow amount for each invoice.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15)
Invoice identifier
PAYMENT_NUM NUMBER (15)
Payment number
DUE_DATE DATE

Payment due date
FIRST_DISCOUNTED_AMT NUMBER

Payment amount less the first discount amount
FIRST_DISC_BASE_AMT NUMBER

Payment amount less the first discount amount in the functional currency
FIRST_DISCOUNT_DATE DATE

Discount date for the first discount
SECOND_DISCOUNTED_AMT NUMBER

Payment amount less the second discount amount
SECOND_DISC_BASE_AMT NUMBER

Payment amount less second discount amount in the functional currency
SECOND_DISCOUNT_DATE DATE

Discount date for the second discount
THIRD_DISCOUNTED_AMT NUMBER

Payment amount less the third discount amount
THIRD_DISC_BASE_AMT NUMBER

Payment amount less third discount amount in the functional currency
THIRD_DISCOUNT_DATE DATE

Discount date for the third discount
CURRENCY_CODE VARCHAR2 (15)
Invoice currency code
PAYMENT_PRIORITY NUMBER

Payment priority for the invoice
VENDOR_TYPE VARCHAR2 (30)
Vendor type defined for the invoice
PAYGROUP VARCHAR2 (25)
Pay group defined for the invoice
ORG_ID NUMBER (15)
Organization identifier
PROJECT_ID NUMBER (15)
Identifier for project used to build default Accounting Flexfield
ON_HOLD VARCHAR2 (1)
Hold placed on invoice
INVOICE_NUM VARCHAR2 (50)
Invoice Number
Query Text

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


SELECT INVOICE_ID
,      PAYMENT_NUM
,      DUE_DATE
,      FIRST_DISCOUNTED_AMT
,      FIRST_DISC_BASE_AMT
,      FIRST_DISCOUNT_DATE
,      SECOND_DISCOUNTED_AMT
,      SECOND_DISC_BASE_AMT
,      SECOND_DISCOUNT_DATE
,      THIRD_DISCOUNTED_AMT
,      THIRD_DISC_BASE_AMT
,      THIRD_DISCOUNT_DATE
,      CURRENCY_CODE
,      PAYMENT_PRIORITY
,      VENDOR_TYPE
,      PAYGROUP
,      ORG_ID
,      PROJECT_ID
,      ON_HOLD
,      INVOICE_NUM
FROM APPS.CE_AP_FC_DISC_INVOICES_V;

Dependencies

[top of page]

APPS.CE_AP_FC_DISC_INVOICES_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_PAYMENT_SCHEDULES_ALL
SynonymAP_SYSTEM_PARAMETERS_ALL
PL/SQL PackageAP_UTILITIES_PKG - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.CE_AP_FC_DISC_INVOICES_V is referenced by following:

SchemaAPPS
ViewCE_DISC_INVOICES_V