[Home] [Help] [Dependency Information]

TABLE: PA.PA_EMPLOYEE_ACCUM_ALL

Object Details

Object Name:	PA_EMPLOYEE_ACCUM_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_EMPLOYEE_ACCUM_ALL
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_EMPLOYEE_ACCUM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID ORGANIZATION_ID PROJECT_TYPE EXPENDITURE_TYPE WEEK_ENDING_DATE ORG_ID
PA_EMPLOYEE_ACCUM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROLLUP_FLAG REQUEST_ID
PA_EMPLOYEE_ACCUM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WEEK_ENDING_DATE

Columns

Query Text

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

SELECT PERSON_ID
,      ORGANIZATION_ID
,      PROJECT_TYPE
,      EXPENDITURE_TYPE
,      WEEK_ENDING_DATE
,      CREATION_DATE
,      CREATED_BY
,      TOTAL_HOURS
,      TOTAL_RAW_COST
,      TOTAL_BURDEN_COST
,      TOTAL_REVENUE
,      BILLABLE_HOURS
,      BILLABLE_RAW_COST
,      BILLABLE_BURDEN_COST
,      INC_TOTAL_HOURS
,      INC_TOTAL_RAW_COST
,      INC_TOTAL_BURDEN_COST
,      INC_TOTAL_REVENUE
,      INC_BILLABLE_HOURS
,      INC_BILLABLE_RAW_COST
,      INC_BILLABLE_BURDEN_COST
,      ROLLUP_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM PA.PA_EMPLOYEE_ACCUM_ALL;

Dependencies

[top of page]

PA.PA_EMPLOYEE_ACCUM_ALL does not reference any database object

PA.PA_EMPLOYEE_ACCUM_ALL is referenced by following:

APPS

PA_EMPLOYEE_ACCUM

PA_EMPLOYEE_ACCUM_ALL