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_RES_LIST_MAP_TMP4

Object Details

Object Name:	PA_RES_LIST_MAP_TMP4
Object Type:	TABLE
Owner:	PA
Subobject Name:
Status:	VALID

Temporary Table Details

PA.PA_RES_LIST_MAP_TMP4 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
PA_RES_LIST_MAP_TMP4_N1	NORMAL	NONUNIQUE	RESOURCE_LIST_MEMBER_ID
PA_RES_LIST_MAP_TMP4_N2	NORMAL	NONUNIQUE	TXN_RESOURCE_ASSIGNMENT_ID
PA_RES_LIST_MAP_TMP4_N3	NORMAL	NONUNIQUE	TXN_SOURCE_ID

Columns

Name	Datatype	Length
PERSON_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
VENDOR_ID	NUMBER	(15)
EXPENDITURE_TYPE	VARCHAR2	(30)
EVENT_TYPE	VARCHAR2	(30)
NON_LABOR_RESOURCE	VARCHAR2	(20)
EXPENDITURE_CATEGORY	VARCHAR2	(30)
REVENUE_CATEGORY	VARCHAR2	(30)
NON_LABOR_RESOURCE_ORG_ID	NUMBER	(15)
EVENT_TYPE_CLASSIFICATION	VARCHAR2	(30)
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)
PROJECT_ROLE_ID	NUMBER	(15)
RESOURCE_TYPE_ID	NUMBER	(15)
RESOURCE_TYPE_CODE	VARCHAR2	(30)
RESOURCE_CLASS_ID	NUMBER	(15)
RESOURCE_CLASS_CODE	VARCHAR2	(30)
RES_FORMAT_ID	NUMBER	(15)
MFC_COST_TYPE_ID	NUMBER	(15)
RESOURCE_CLASS_FLAG	VARCHAR2	(1)
FC_RES_TYPE_CODE	VARCHAR2	(30)
BOM_LABOR_RESOURCE_ID	NUMBER	(15)
BOM_EQUIP_RESOURCE_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(15)
ITEM_CATEGORY_ID	NUMBER	(15)
PERSON_TYPE_CODE	VARCHAR2	(30)
BOM_RESOURCE_ID	NUMBER	(15)
NAMED_ROLE	VARCHAR2	(80)
INCURRED_BY_RES_FLAG	VARCHAR2	(1)
TXN_COPY_FROM_RL_FLAG	VARCHAR2	(1)
TXN_SPREAD_CURVE_ID	NUMBER	(15)
TXN_ETC_METHOD_CODE	VARCHAR2	(30)
TXN_OBJECT_TYPE	VARCHAR2	(30)
TXN_OBJECT_ID	NUMBER	(15)
TXN_PROJECT_ID	NUMBER	(15)
TXN_BUDGET_VERSION_ID	NUMBER	(15)
TXN_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
TXN_RESOURCE_ID	NUMBER	(15)
TXN_ALIAS	VARCHAR2	(80)
TXN_TRACK_AS_LABOR_FLAG	VARCHAR2	(1)
TXN_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(30)
TXN_SOURCE_ID	NUMBER	(15)
TXN_SOURCE_TYPE_CODE	VARCHAR2	(30)
TXN_PROCESS_CODE	VARCHAR2	(30)
TXN_ERROR_MSG_CODE	VARCHAR2	(30)
TXN_TASK_ID	NUMBER	(15)
TXN_WBS_ELEMENT_VERSION_ID	NUMBER	(15)
TXN_RBS_ELEMENT_ID	NUMBER	(15)
TXN_RBS_ELEMENT_VERSION_ID	NUMBER	(15)
TXN_PLANNING_START_DATE	DATE
TXN_PLANNING_END_DATE	DATE
TXN_RECORD_VERSION_NUMBER	NUMBER
TXN_SP_FIXED_DATE	DATE
TXN_RATE_BASED_FLAG	VARCHAR2	(1)
TXN_RES_CLASS_BILL_RATE_SCH_ID	NUMBER	(15)
TXN_RES_CLASS_COST_SCH_ID	NUMBER	(15)
TXN_USE_PLANNING_RATES_FLAG	VARCHAR2	(1)
TXN_BILL_JOB_GROUP_ID	NUMBER	(15)
TXN_PROJECT_CURRENCY_CODE	VARCHAR2	(30)
TXN_PROJFUNC_CURRENCY_CODE	VARCHAR2	(30)
TXN_EMP_BILL_RATE_SCHEDULE_ID	NUMBER	(15)
TXN_JOB_BILL_RATE_SCHEDULE_ID	NUMBER	(15)
TXN_LABOR_BILL_RATE_ORG_ID	NUMBER	(15)
TXN_LABOR_SCH_TYPE	VARCHAR2	(1)
TXN_LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)
TXN_LABOR_SCHEDULE_FIXED_DATE	DATE
TXN_LABOR_STD_BILL_RATE_SCHDL	VARCHAR2	(20)
TXN_CURRENCY_CODE	VARCHAR2	(30)
TXN_PLAN_QUANTITY	NUMBER
TXN_RESOURCE_ASSIGNMENT_ID	NUMBER	(15)
TMP_ROWID	ROWID	(10)
RUN_NUMBER	NUMBER	(15)
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)

Query Text

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


SELECT PERSON_ID
,      JOB_ID
,      ORGANIZATION_ID
,      VENDOR_ID
,      EXPENDITURE_TYPE
,      EVENT_TYPE
,      NON_LABOR_RESOURCE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      NON_LABOR_RESOURCE_ORG_ID
,      EVENT_TYPE_CLASSIFICATION
,      SYSTEM_LINKAGE_FUNCTION
,      PROJECT_ROLE_ID
,      RESOURCE_TYPE_ID
,      RESOURCE_TYPE_CODE
,      RESOURCE_CLASS_ID
,      RESOURCE_CLASS_CODE
,      RES_FORMAT_ID
,      MFC_COST_TYPE_ID
,      RESOURCE_CLASS_FLAG
,      FC_RES_TYPE_CODE
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIP_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      PERSON_TYPE_CODE
,      BOM_RESOURCE_ID
,      NAMED_ROLE
,      INCURRED_BY_RES_FLAG
,      TXN_COPY_FROM_RL_FLAG
,      TXN_SPREAD_CURVE_ID
,      TXN_ETC_METHOD_CODE
,      TXN_OBJECT_TYPE
,      TXN_OBJECT_ID
,      TXN_PROJECT_ID
,      TXN_BUDGET_VERSION_ID
,      TXN_RESOURCE_LIST_MEMBER_ID
,      TXN_RESOURCE_ID
,      TXN_ALIAS
,      TXN_TRACK_AS_LABOR_FLAG
,      TXN_FUNDS_CONTROL_LEVEL_CODE
,      TXN_SOURCE_ID
,      TXN_SOURCE_TYPE_CODE
,      TXN_PROCESS_CODE
,      TXN_ERROR_MSG_CODE
,      TXN_TASK_ID
,      TXN_WBS_ELEMENT_VERSION_ID
,      TXN_RBS_ELEMENT_ID
,      TXN_RBS_ELEMENT_VERSION_ID
,      TXN_PLANNING_START_DATE
,      TXN_PLANNING_END_DATE
,      TXN_RECORD_VERSION_NUMBER
,      TXN_SP_FIXED_DATE
,      TXN_RATE_BASED_FLAG
,      TXN_RES_CLASS_BILL_RATE_SCH_ID
,      TXN_RES_CLASS_COST_SCH_ID
,      TXN_USE_PLANNING_RATES_FLAG
,      TXN_BILL_JOB_GROUP_ID
,      TXN_PROJECT_CURRENCY_CODE
,      TXN_PROJFUNC_CURRENCY_CODE
,      TXN_EMP_BILL_RATE_SCHEDULE_ID
,      TXN_JOB_BILL_RATE_SCHEDULE_ID
,      TXN_LABOR_BILL_RATE_ORG_ID
,      TXN_LABOR_SCH_TYPE
,      TXN_LABOR_SCHEDULE_DISCOUNT
,      TXN_LABOR_SCHEDULE_FIXED_DATE
,      TXN_LABOR_STD_BILL_RATE_SCHDL
,      TXN_CURRENCY_CODE
,      TXN_PLAN_QUANTITY
,      TXN_RESOURCE_ASSIGNMENT_ID
,      TMP_ROWID
,      RUN_NUMBER
,      RESOURCE_LIST_MEMBER_ID
FROM PA.PA_RES_LIST_MAP_TMP4;

Dependencies

[top of page]

PA.PA_RES_LIST_MAP_TMP4 does not reference any database object

PA.PA_RES_LIST_MAP_TMP4 is referenced by following:

APPS: PA_RES_LIST_MAP_TMP4