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_TMP3

Object Details

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

Temporary Table Details

PA.PA_RES_LIST_MAP_TMP3 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

Columns

Name	Datatype	Length
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
RES_LIST_MEM_SEQ	NUMBER	(15)
RES_FORMAT_ID	NUMBER	(15)
BOM_LABOR_RESOURCE_ID	NUMBER	(15)
BOM_EQUIP_RESOURCE_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)
EVENT_TYPE	VARCHAR2	(30)
EXPENDITURE_CATEGORY	VARCHAR2	(30)
EXPENDITURE_TYPE	VARCHAR2	(30)
ITEM_CATEGORY_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
PERSON_TYPE_CODE	VARCHAR2	(30)
NON_LABOR_RESOURCE	VARCHAR2	(20)
REVENUE_CATEGORY	VARCHAR2	(30)
VENDOR_ID	NUMBER	(15)
PROJECT_ROLE_ID	NUMBER	(15)
RESOURCE_CLASS_CODE	VARCHAR2	(30)
FC_RES_TYPE_CODE	VARCHAR2	(30)
NAMED_ROLE	VARCHAR2	(80)
BOM_RESOURCE_ID	NUMBER	(15)
INCURRED_BY_RES_FLAG	VARCHAR2	(1)
RESOURCE_CLASS_ID	NUMBER	(15)

Query Text

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


SELECT RESOURCE_LIST_MEMBER_ID
,      RES_LIST_MEM_SEQ
,      RES_FORMAT_ID
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIP_RESOURCE_ID
,      PERSON_ID
,      EVENT_TYPE
,      EXPENDITURE_CATEGORY
,      EXPENDITURE_TYPE
,      ITEM_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      JOB_ID
,      ORGANIZATION_ID
,      PERSON_TYPE_CODE
,      NON_LABOR_RESOURCE
,      REVENUE_CATEGORY
,      VENDOR_ID
,      PROJECT_ROLE_ID
,      RESOURCE_CLASS_CODE
,      FC_RES_TYPE_CODE
,      NAMED_ROLE
,      BOM_RESOURCE_ID
,      INCURRED_BY_RES_FLAG
,      RESOURCE_CLASS_ID
FROM PA.PA_RES_LIST_MAP_TMP3;

Dependencies

[top of page]

PA.PA_RES_LIST_MAP_TMP3 does not reference any database object

PA.PA_RES_LIST_MAP_TMP3 is referenced by following:

APPS: PA_RES_LIST_MAP_TMP3