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

VIEW: APPS.CE_DUE_PROJECT_INV_V

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

View Type

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


The Cash Forecasting program uses this view to generate cash outflow amounts from unpaid AP invoices when project information is entered as a submission parameter. This view has project information plus all the columns in CE_AP_FC_DUE_INVOICES_V.


[View Source]

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

Payment amount
BASE_AMOUNT NUMBER

Payment amount in the functional currency
CURRENCY_CODE VARCHAR2 (15) Yes Currency code of the invoice
PAYMENT_PRIORITY NUMBER

Payment priority assigned for the invoice
VENDOR_TYPE VARCHAR2 (30)
Vendor type code assigned for the invoice
PAYGROUP VARCHAR2 (25)
Pay group code assigned for the invoice
TRX_DATE DATE

Payment due date
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) Yes Invoice Number
REFERENCE_ID VARCHAR2 (81)
Reference identifier
Query Text

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


SELECT INVOICE_ID
,      PAYMENT_NUM
,      AMOUNT
,      BASE_AMOUNT
,      CURRENCY_CODE
,      PAYMENT_PRIORITY
,      VENDOR_TYPE
,      PAYGROUP
,      TRX_DATE
,      ORG_ID
,      PROJECT_ID
,      ON_HOLD
,      INVOICE_NUM
,      REFERENCE_ID
FROM APPS.CE_DUE_PROJECT_INV_V;

Dependencies

[top of page]

APPS.CE_DUE_PROJECT_INV_V references the following:

SchemaAPPS
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
PL/SQL PackageAP_UTILITIES_PKG - show dependent code
ViewCE_AP_FC_DUE_INVOICES_V
APPS.CE_DUE_PROJECT_INV_V is referenced by following:

SchemaAPPS
ViewCE_FC_API_DISC_V