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

VIEW: APPS.PA_STATUS_RSRC_EI_BASE_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
TXN_ACCUM_ID NUMBER (15)
PA_PERIOD VARCHAR2 (20)
PA_START_DATE DATE

PA_END_DATE DATE

EXPENDITURE_ITEM_ID NUMBER

QUANTITY NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

BILLABLE_QUANTITY NUMBER

BILLABLE_RAW_COST NUMBER

BILLABLE_BURDENED_COST NUMBER

REVENUE NUMBER

DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      TXN_ACCUM_ID
,      PA_PERIOD
,      PA_START_DATE
,      PA_END_DATE
,      EXPENDITURE_ITEM_ID
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      BILLABLE_QUANTITY
,      BILLABLE_RAW_COST
,      BILLABLE_BURDENED_COST
,      REVENUE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
FROM APPS.PA_STATUS_RSRC_EI_BASE_V;

Dependencies

[top of page]

APPS.PA_STATUS_RSRC_EI_BASE_V references the following:

SchemaAPPS
SynonymPA_COST_DISTRIBUTION_LINES_ALL
SynonymPA_CUST_REV_DIST_LINES_ALL
SynonymPA_PERIODS
SynonymPA_RESOURCE_ACCUM_DETAILS
PL/SQL PackagePA_STATUS - show dependent code
SynonymPA_TXN_ACCUM
SynonymPA_TXN_ACCUM_DETAILS
APPS.PA_STATUS_RSRC_EI_BASE_V is referenced by following:

SchemaAPPS
ViewPA_STATUS_EI_BASE_V