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_EI_CDL_CM_GTEMP2

Object Details

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

Temporary Table Details

PA.PA_EI_CDL_CM_GTEMP2 is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER
PA_DATE	DATE
PA_PERIOD_NAME	VARCHAR2	(4000)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PERSON_TYPE	VARCHAR2	(30)
PO_LINE_ID	NUMBER
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)
EI_EXPENDITURE_TYPE	VARCHAR2	(30)
IND_COMPILED_SET_ID	NUMBER	(15)
PREV_IND_COMPILED_SET_ID	NUMBER	(15)
EXPENDITURE_ITEM_ID	NUMBER	(15)
LINE_NUM	NUMBER	(15)
EXPENDITURE_ITEM_DATE	DATE
CDL_AMOUNT	NUMBER
CDL_PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
CDL_DENOM_RAW_COST	NUMBER
CDL_DENOM_CURRENCY_CODE	VARCHAR2	(15)
CDL_ACCT_RAW_COST	NUMBER
CDL_ACCT_CURRENCY_CODE	VARCHAR2	(15)
CDL_PROJECT_RAW_COST	NUMBER
CDL_PROJECT_CURRENCY_CODE	VARCHAR2	(15)
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)
SYSTEM_REFERENCE1	VARCHAR2	(30)
DENOM_CURRENCY_CODE	VARCHAR2	(15)
ACCT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
BILLABLE_FLAG	VARCHAR2	(1)
REQUEST_ID	NUMBER	(15)
ADJUSTMENT_TYPE	VARCHAR2	(150)
JOB_ID	NUMBER	(15)
NON_LABOR_RESOURCE	VARCHAR2	(20)
NON_LABOR_RESOURCE_ORGN_ID	NUMBER	(15)
WIP_RESOURCE_ID	NUMBER
INCURRED_BY_PERSON_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER
COST_PLUS_STRUCTURE	VARCHAR2	(30)
COST_BASE	VARCHAR2	(30)
ORG_ID	NUMBER	(15)
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_EXCHANGE_RATE	NUMBER
PROJECT_RATE_DATE	DATE
PROJECT_RATE_TYPE	VARCHAR2	(30)
PROJECT_EXCHANGE_RATE	NUMBER
PROJFUNC_COST_RATE_DATE	DATE
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
CBS_ELEMENT_ID	NUMBER	(15)

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      PA_DATE
,      PA_PERIOD_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE_CATEGORY
,      PERSON_TYPE
,      PO_LINE_ID
,      SYSTEM_LINKAGE_FUNCTION
,      EI_EXPENDITURE_TYPE
,      IND_COMPILED_SET_ID
,      PREV_IND_COMPILED_SET_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      EXPENDITURE_ITEM_DATE
,      CDL_AMOUNT
,      CDL_PROJFUNC_CURRENCY_CODE
,      CDL_DENOM_RAW_COST
,      CDL_DENOM_CURRENCY_CODE
,      CDL_ACCT_RAW_COST
,      CDL_ACCT_CURRENCY_CODE
,      CDL_PROJECT_RAW_COST
,      CDL_PROJECT_CURRENCY_CODE
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      SYSTEM_REFERENCE1
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      PROJFUNC_CURRENCY_CODE
,      BILLABLE_FLAG
,      REQUEST_ID
,      ADJUSTMENT_TYPE
,      JOB_ID
,      NON_LABOR_RESOURCE
,      NON_LABOR_RESOURCE_ORGN_ID
,      WIP_RESOURCE_ID
,      INCURRED_BY_PERSON_ID
,      INVENTORY_ITEM_ID
,      COST_PLUS_STRUCTURE
,      COST_BASE
,      ORG_ID
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      CBS_ELEMENT_ID
FROM PA.PA_EI_CDL_CM_GTEMP2;

Dependencies

[top of page]

PA.PA_EI_CDL_CM_GTEMP2 does not reference any database object

PA.PA_EI_CDL_CM_GTEMP2 is referenced by following:

APPS: PA_EI_CDL_CM_GTEMP2