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

TABLE: PA.PA_AUD_COST_DIST_LINES

Object Details
Object Name: PA_AUD_COST_DIST_LINES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_AUD_COST_DIST_LINES
Subobject Name:
Status: VALID


PA_AUD_COST_DIST_LINES stores audit information for summarized burden expenditure items. The BURDEN_SUM_SOURCE_RUN_ID identifies the cost distribution lines that were summarized to create the burden expenditure items. The IND_COMPILED_SET_ID identifies the burden rates used to calculate the burden cost amounts.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_ITEM_ID NUMBER (15) Yes The identifier of the expenditure item that is cost distributed by the distribution line.
LINE_NUM NUMBER (15) Yes The sequential number that identifies the cost distribution line
IND_COMPILED_SET_ID NUMBER (15)
The identifier of the compiled set used to calculate the burden cost.
BURDEN_SUM_SOURCE_RUN_ID NUMBER (15)
Identifies the group of cost distribution lines that were summarized to create burden cost expenditure items.
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
PROGRAM_ID NUMBER (15)
Standard Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who Column
REQUEST_ID NUMBER (15)
Standard Who Column
Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      LINE_NUM
,      IND_COMPILED_SET_ID
,      BURDEN_SUM_SOURCE_RUN_ID
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM PA.PA_AUD_COST_DIST_LINES;

Dependencies

[top of page]

PA.PA_AUD_COST_DIST_LINES does not reference any database object

PA.PA_AUD_COST_DIST_LINES is referenced by following:

SchemaPA
ViewPA_AUD_COST_DIST_LINES#