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


VIEW: APPS.PA_FC_ACTUAL_DTLS_V

Object Details
Object Name: PA_FC_ACTUAL_DTLS_V
Object Type: VIEW
Owner: APPS
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
EXPENDITURE_ITEM_ID NUMBER (15)
PROJECT_ID NUMBER (15)

TASK_ID NUMBER (15)

TASK_NUMBER VARCHAR2 (25)
User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. However note: task numbers do not record the wbs structure
EXPENDITURE_TYPE VARCHAR2 (30)

EXPENDITURE_CATEGORY VARCHAR2 (30)
The expenditure category that classifies the expenditure type into a cost group
EXPENDITURE_ITEM_DATE DATE


SUPPLIER_NAME VARCHAR2 (240)
Supplier name
TRANSACTION_SOURCE VARCHAR2 (30)

QUANTITY NUMBER


DENOM_RAW_COST NUMBER

Raw cost in denomination currency
DENOM_BURDENED_COST NUMBER

Burdened cost in Denomination currency
DENOM_CURRENCY_CODE VARCHAR2 (15)
Denomination currency code of the transaction
PROJECT_RAW_COST NUMBER

Project Raw Cost
PROJECT_BURDENED_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code of the transaction
PROJECT_RATE_TYPE VARCHAR2 (30)
Project rate type for the transaction
PROJECT_RATE_DATE DATE

Project rate date for the transaction
PROJECT_EXCHANGE_RATE NUMBER

Project exchange rate for the transaction
ACCT_RAW_COST NUMBER

Raw cost in accounting currency
ACCT_BURDENED_COST NUMBER

Burdened cost in Accounting currency
ACCT_CURRENCY_CODE VARCHAR2 (15)
Account currency code of the transaction
ACCT_RATE_DATE DATE

Accounting rate date for the transaction
ACCT_RATE_TYPE VARCHAR2 (30)
Accounting rate type for the transaction
ACCT_EXCHANGE_RATE NUMBER

Accounting exchange rate for the transaction
PROJFUNC_CURR_CODE VARCHAR2 (15)
Project functional currency code
PROJFUNC_RATE_TYPE VARCHAR2 (30)
Project functional cost rate type
PROJFUNC_RATE_DATE DATE

Project functional cost rate date
PROJFUNC_EXCHANGE_RATE NUMBER

Project functional cost exchange rate
PA_DATE DATE


PA_PERIOD_NAME VARCHAR2 (15)
PA Period Name
GL_DATE DATE


GL_PERIOD_NAME VARCHAR2 (15)
GL Period Name
DOCUMENT_NAME VARCHAR2 (50)
DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_LINE_NUM NUMBER

DOCUMENT_LINE_NUMBER NUMBER (15)
DOCUMENT_DISTRIBUTION_NUMBER NUMBER

DOCUMENT_DISTRIBUTION_ID NUMBER (15)
SUPPLIER_ID NUMBER

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      PROJECT_ID
,      TASK_ID
,      TASK_NUMBER
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      EXPENDITURE_ITEM_DATE
,      SUPPLIER_NAME
,      TRANSACTION_SOURCE
,      QUANTITY
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      DENOM_CURRENCY_CODE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PROJFUNC_CURR_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      PA_DATE
,      PA_PERIOD_NAME
,      GL_DATE
,      GL_PERIOD_NAME
,      DOCUMENT_NAME
,      DOCUMENT_HEADER_ID
,      DOCUMENT_LINE_NUM
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_DISTRIBUTION_NUMBER
,      DOCUMENT_DISTRIBUTION_ID
,      SUPPLIER_ID
FROM APPS.PA_FC_ACTUAL_DTLS_V;

Dependencies

[top of page]

APPS.PA_FC_ACTUAL_DTLS_V references the following:

SchemaAPPS
SynonymAP_INVOICES
SynonymAP_INVOICE_DISTRIBUTIONS
SynonymAP_INVOICE_LINES
SynonymPA_COST_DISTRIBUTION_LINES
SynonymPA_EXPENDITURE_ITEMS
SynonymPA_EXPENDITURE_TYPES
SynonymPA_TASKS
SynonymPO_DISTRIBUTIONS
SynonymPO_HEADERS
SynonymPO_LINES
ViewPO_VENDORS

APPS.PA_FC_ACTUAL_DTLS_V is not referenced by any database object