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

TABLE: PA.PA_EXPENDITURE_COST_RATES_ALL

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


PA_EXPENDITURE_COST_RATES_ALL stores cost rates of
non-labor expenditure types defined with COST_RATE_FLAG
set to 'Y'.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_EXPENDITURE_COST_RATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXPENDITURE_TYPE
ColumnSTART_DATE_ACTIVE
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_TYPE VARCHAR2 (30) Yes The non-labor expenditure type for which the cost rate is entered
START_DATE_ACTIVE DATE
Yes First effective date of the expenditure cost rate
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
COST_RATE NUMBER (22) Yes The cost rate used to determine a non-labor item's raw cost. Raw cost = cost rate * quantity
END_DATE_ACTIVE DATE

Last effective date of the expenditure cost rate
ORG_ID NUMBER (15)
Operating unit identifier for multi-organization installations
Query Text

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


SELECT EXPENDITURE_TYPE
,      START_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COST_RATE
,      END_DATE_ACTIVE
,      ORG_ID
FROM PA.PA_EXPENDITURE_COST_RATES_ALL;

Dependencies

[top of page]

PA.PA_EXPENDITURE_COST_RATES_ALL does not reference any database object

PA.PA_EXPENDITURE_COST_RATES_ALL is referenced by following:

SchemaPA
ViewPA_EXPENDITURE_COST_RATES_ALL#