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_GTEMP

Object Details

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

This global temporary table is created for storing the valid CDL details to be picked up by create and distribute burden trasactions process for creating burden transactions

Temporary Table Details

PA.PA_EI_CDL_CM_GTEMP 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	Comments
PROJECT_ID	NUMBER	(15)	Project id of the cost distribution line item whose burden components are being summarized
TASK_ID	NUMBER	(15)	task id of the cost distribution line item whose burden components are being summarized
ORGANIZATION_ID	NUMBER		Organization actually incurred the expenses or the overriding organization of an expenditure item
PA_DATE	DATE		Account period end date of an expenditure item
PA_PERIOD_NAME	VARCHAR2	(4000)	Account period name of an expenditure item
ATTRIBUTE1	VARCHAR2	(150)	Flex field used for customization.This field is used by GMS to store the award_id which sponsers the project/task of an expenditure item
ATTRIBUTE2	VARCHAR2	(150)	Flex field used for customization.This field is used by GMS to store the award_id which sponsers the project/task of an expenditure item
ATTRIBUTE3	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE4	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE5	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE6	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE7	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE8	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE9	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE10	VARCHAR2	(150)	Flex field used for customization
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Flex field used for customization
PERSON_TYPE	VARCHAR2	(30)	Type of person who incurred the expenditure
PO_LINE_ID	NUMBER		Purchase order line identifier for imported contingent worker labor transactions
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	System Linkage Function of the Expenditure Item
EI_EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type of an expenditure item
IND_COMPILED_SET_ID	NUMBER	(15)	Indirect complied set id
PREV_IND_COMPILED_SET_ID	NUMBER	(15)	previous ind compiled set id marked on CDL in case the respective EI marked for burden_resummarize
EXPENDITURE_ITEM_ID	NUMBER	(15)	Identifier of the expenditure item being used for burden summarization
LINE_NUM	NUMBER	(15)	Line item number of the CDL of an expenditure item
EXPENDITURE_ITEM_DATE	DATE		Date of creation of the line_item
CDL_AMOUNT	NUMBER		Project Functional Raw Cost
CDL_PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)	CDL Project Functional Currency Code (Not used)
CDL_DENOM_RAW_COST	NUMBER		Transaction Cost
CDL_DENOM_CURRENCY_CODE	VARCHAR2	(15)	CDL Denom Currency Code (Not used)
CDL_ACCT_RAW_COST	NUMBER		Actual Raw Cost
CDL_ACCT_CURRENCY_CODE	VARCHAR2	(15)	CDL Acct Currency Code (Not used)
CDL_PROJECT_RAW_COST	NUMBER		Project Raw Amount
CDL_PROJECT_CURRENCY_CODE	VARCHAR2	(15)	CDL Project Currency Code (Not used)
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)	Unique number identifying the run of a burden summarization process. All the CDLs processed,summarized burden \ expenditure items created during a run are stamped with one run id fro sequence pa_burden_sum_run_id_s
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)	Code identifies the rejection reason for a CDL during summarization. Rejected CDLs can be corrected for the \ error and they will be summarized in the susequent run
SYSTEM_REFERENCE1	VARCHAR2	(30)	For Supplier Invoices, holds the Vendor Id
DENOM_CURRENCY_CODE	VARCHAR2	(15)	EI Denom Currency Code
ACCT_CURRENCY_CODE	VARCHAR2	(15)	EI Acct Currency Code
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	EI Project Currency Code
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)	EI Project Functional Currency Code
BILLABLE_FLAG	VARCHAR2	(1)	For Expenditure Items holds Billable Flag
REQUEST_ID	NUMBER	(15)	Request Id stamped temporarily during processing on the CDL of an Expenditure Item
ADJUSTMENT_TYPE	VARCHAR2	(150)	Adjustment Type Code
JOB_ID	NUMBER	(15)	Identifier of the job of employee
NON_LABOR_RESOURCE	VARCHAR2	(20)	Non Labor Resource
NON_LABOR_RESOURCE_ORGN_ID	NUMBER	(15)	Identifier of the organization that owns the non labor resource
WIP_RESOURCE_ID	NUMBER		Identifier of the resource for work in progress
INCURRED_BY_PERSON_ID	NUMBER	(15)	Identifier of the employee who incurred the charges
INVENTORY_ITEM_ID	NUMBER		Identifier of the inventory item
COST_PLUS_STRUCTURE	VARCHAR2	(30)	cost plus structure which belongs to the ind complied set id
COST_BASE	VARCHAR2	(30)	Cost base code of the expenditure item
ORG_ID	NUMBER	(15)	Identifier of the Expenditure Operating Unit
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

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
FROM PA.PA_EI_CDL_CM_GTEMP;

Dependencies

[top of page]

PA.PA_EI_CDL_CM_GTEMP does not reference any database object

PA.PA_EI_CDL_CM_GTEMP is referenced by following:

APPS: PA_EI_CDL_CM_GTEMP