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

VIEW: APPS.PA_CE_EXP_REPORTS_V

Object Details
Object Name: PA_CE_EXP_REPORTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CE_EXP_REPORTS_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 transactions
AMOUNT NUMBER

Amount of the item in the reimbersement currency
BASE_AMOUNT NUMBER

Amount of the item in the functional currency
CURRENCY_CODE VARCHAR2 (15)
Reimbersement currency code for the item
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code of the item
TRX_DATE DATE
Yes Expenditure ending date for the item
ORG_ID NUMBER (15)
Operating unit id from Expenditure_Items table
EXPENDITURE_ITEM_ID NUMBER (15) Yes The internal identifier of the transaction
BILL_HOLD_FLAG VARCHAR2 (1) Yes The flag that identifies if the transaction is on hold
TRANSACTION_SOURCE VARCHAR2 (30)
Only populated for expenditure items created from transactions imported into PA from an external system; used by PA's expenditure item adjustment modules and costing programs to ensure the proper processing on imported items
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
,      EXPENDITURE_ITEM_ID
,      BILL_HOLD_FLAG
,      TRANSACTION_SOURCE
FROM APPS.PA_CE_EXP_REPORTS_V;

Dependencies

[top of page]

APPS.PA_CE_EXP_REPORTS_V references the following:

SchemaAPPS
SynonymPA_COST_DISTRIBUTION_LINES_ALL
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_TASKS
APPS.PA_CE_EXP_REPORTS_V is referenced by following:

SchemaAPPS
ViewCE_FC_APX_DISC_V