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


TABLE: PA.PA_BUDGET_LINES_EFC

Object Details
Object Name: PA_BUDGET_LINES_EFC
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_BUDGET_LINES_EFC
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER
Yes
RESOURCE_ASSIGNMENT_ID NUMBER
Yes
START_DATE DATE
Yes
CREATION_DATE DATE
Yes
END_DATE DATE
Yes
PERIOD_NAME VARCHAR2 (30)
QUANTITY NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE NUMBER

CHANGE_REASON_CODE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (255)
RAW_COST_SOURCE VARCHAR2 (2)
BURDENED_COST_SOURCE VARCHAR2 (2)
QUANTITY_SOURCE VARCHAR2 (2)
REVENUE_SOURCE VARCHAR2 (2)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_BUDGET_LINE_REFERENCE VARCHAR2 (25)
ADJUSTED_EFC_REVENUE_AMT NUMBER

Query Text

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


SELECT SET_OF_BOOKS_ID
,      RESOURCE_ASSIGNMENT_ID
,      START_DATE
,      CREATION_DATE
,      END_DATE
,      PERIOD_NAME
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      CHANGE_REASON_CODE
,      DESCRIPTION
,      RAW_COST_SOURCE
,      BURDENED_COST_SOURCE
,      QUANTITY_SOURCE
,      REVENUE_SOURCE
,      PM_PRODUCT_CODE
,      PM_BUDGET_LINE_REFERENCE
,      ADJUSTED_EFC_REVENUE_AMT
FROM PA.PA_BUDGET_LINES_EFC;

Dependencies

[top of page]

PA.PA_BUDGET_LINES_EFC does not reference any database object

PA.PA_BUDGET_LINES_EFC is referenced by following:

SchemaAPPS
SynonymPA_BUDGET_LINES_EFC