eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_TSK_ACT_CMT_IT_ALL

Object Details

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

View Type

Internal

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TSK_ACT_CMT_IT_ALL_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	TASK_ACT_CMT_KEY
PA_TSK_ACT_CMT_IT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TASK_ID PA_PERIOD_KEY RESOURCE_LIST_MEMBER_ID

Columns

Name	Datatype	Length	Mandatory
TASK_ACT_CMT_KEY	VARCHAR2	(500)	Yes
TASK_ID	NUMBER	(15)	Yes
PA_PERIOD_KEY	VARCHAR2	(40)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
EXPENSE_ORGANIZATION_ID	NUMBER	(15)
OWNER_ORGANIZATION_ID	NUMBER	(15)
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
SERVICE_TYPE_CODE	VARCHAR2	(30)
EXPENDITURE_TYPE	VARCHAR2	(30)
USER_COL1	VARCHAR2	(15)
USER_COL2	VARCHAR2	(15)
USER_COL3	VARCHAR2	(15)
USER_COL4	VARCHAR2	(15)
USER_COL5	VARCHAR2	(15)
USER_COL6	NUMBER
USER_COL7	NUMBER
USER_COL8	NUMBER
USER_COL9	NUMBER
USER_COL10	NUMBER
ACCUME_REVENUE	NUMBER
ACCUME_RAW_COST	NUMBER
ACCUME_BURDENED_COST	NUMBER
ACCUME_QUANTITY	NUMBER
ACCUME_LABOR_HOURS	NUMBER
ACCUME_BILLABLE_RAW_COST	NUMBER
ACCUME_BILLABLE_BURDENED_COST	NUMBER
ACCUME_BILLABLE_QUANTITY	NUMBER
ACCUME_BILLABLE_LABOR_HOURS	NUMBER
ACCUME_CMT_RAW_COST	NUMBER
ACCUME_CMT_BURDENED_COST	NUMBER
ACCUME_CMT_QUANTITY	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(30)
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
STATUS_CODE	VARCHAR2	(1)
ORG_ID	NUMBER	(15)

Query Text

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


SELECT TASK_ACT_CMT_KEY
,      TASK_ID
,      PA_PERIOD_KEY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      EXPENSE_ORGANIZATION_ID
,      OWNER_ORGANIZATION_ID
,      RESOURCE_LIST_MEMBER_ID
,      SERVICE_TYPE_CODE
,      EXPENDITURE_TYPE
,      USER_COL1
,      USER_COL2
,      USER_COL3
,      USER_COL4
,      USER_COL5
,      USER_COL6
,      USER_COL7
,      USER_COL8
,      USER_COL9
,      USER_COL10
,      ACCUME_REVENUE
,      ACCUME_RAW_COST
,      ACCUME_BURDENED_COST
,      ACCUME_QUANTITY
,      ACCUME_LABOR_HOURS
,      ACCUME_BILLABLE_RAW_COST
,      ACCUME_BILLABLE_BURDENED_COST
,      ACCUME_BILLABLE_QUANTITY
,      ACCUME_BILLABLE_LABOR_HOURS
,      ACCUME_CMT_RAW_COST
,      ACCUME_CMT_BURDENED_COST
,      ACCUME_CMT_QUANTITY
,      UNIT_OF_MEASURE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS_CODE
,      ORG_ID
FROM PA.PA_TSK_ACT_CMT_IT_ALL;

Dependencies

[top of page]

PA.PA_TSK_ACT_CMT_IT_ALL does not reference any database object

PA.PA_TSK_ACT_CMT_IT_ALL is referenced by following:

APPS: PA_TSK_ACT_CMT_IT; PA_TSK_ACT_CMT_IT_ALL