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

VIEW: APPS.PA_CE_INVOICES_V

Object Details
Object Name: PA_CE_INVOICES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CE_INVOICES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Project identifier for the transaction
AMOUNT NUMBER

Total amount of the invoice in invoice currency
BASE_AMOUNT NUMBER (22) Yes Total amount of the invoice in project functional currency
CURRENCY_CODE VARCHAR2 (15)
Invoice currency code
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15) Yes Functional currency code
TRX_DATE DATE

Invoice date of the invoice
ORG_ID NUMBER (15)
Operating unit id
PROFILE_CLASS_ID NUMBER

This is the customer profile id associated with customer record in AR
TRX_NUMBER NUMBER (15) Yes The draft invoice number to which the invoice line belongs
LINE_NUM NUMBER (15) Yes The sequential number that identifies and orders the draft invoice item for a draft invoices
Query Text

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


SELECT PROJECT_ID
,      AMOUNT
,      BASE_AMOUNT
,      CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      TRX_DATE
,      ORG_ID
,      PROFILE_CLASS_ID
,      TRX_NUMBER
,      LINE_NUM
FROM APPS.PA_CE_INVOICES_V;

Dependencies

[top of page]

APPS.PA_CE_INVOICES_V references the following:

SchemaAPPS
SynonymHZ_CUSTOMER_PROFILES
SynonymHZ_CUST_SITE_USES_ALL
SynonymPA_DRAFT_INVOICES_ALL
SynonymPA_DRAFT_INVOICE_ITEMS
SynonymPA_PROJECTS_ALL
APPS.PA_CE_INVOICES_V is referenced by following:

SchemaAPPS
ViewCE_FC_ARI_DISC_V