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_MEMBERS_TEMP

Object Details

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

Stores all default resource attributes which are derived based on the
resource_list_member_id.

Temporary Table Details

PA.PA_RES_MEMBERS_TEMP 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
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	List of Planning RESOURCES MEMBER ID.
ORDER_ID	NUMBER
RESOURCE_CLASS_FLAG	VARCHAR2	(1)	RESOURCE_CLASS_FLAG from PA_RESOURCE_LIST_MEMBERS
RESOURCE_CLASS_CODE	VARCHAR2	(30)	RESOURCE_CLASS_CODE from PA_RESOURCE_LIST_MEMBERS.
RESOURCE_CLASS_ID	NUMBER	(15)	RESOURCE_CLASS_ID from PA_RESOURCE_LIST_MEMBERS.
RES_TYPE_CODE	VARCHAR2	(30)	Derived column from pa_res_types_b..
PERSON_ID	NUMBER	(15)	PERSON_ID from PA_RESOURCE_LIST_MEMBERS.
JOB_ID	NUMBER	(15)	JOB_ID from PA_RESOURCE_LIST_MEMBERS.
PERSON_TYPE_CODE	VARCHAR2	(30)	PERSON_TYPE_CODE from PA_RESOURCE_LIST_MEMBERS.
NAMED_ROLE	VARCHAR2	(80)	NAMED_ROLE from PA_RESOURCE_LIST_MEMBERS.
BOM_RESOURCE_ID	NUMBER	(15)	BOM_RESOURCE_ID from PA_RESOURCE_LIST_MEMBERS.
NON_LABOR_RESOURCE	VARCHAR2	(20)	NON_LABOR_RESOURCE from PA_RESOURCE_LIST_MEMBERS.
INVENTORY_ITEM_ID	NUMBER	(15)	INVENTORY_ITEM_ID from PA_RESOURCE_LIST_MEMBERS.
ITEM_CATEGORY_ID	NUMBER	(15)	ITEM_CATEGORY_ID from PA_RESOURCE_LIST_MEMBERS.
PROJECT_ROLE_ID	NUMBER	(15)	PROJECT_ROLE_ID from PA_RESOURCE_LIST_MEMBERS.
ORGANIZATION_ID	NUMBER	(15)	ORGANIZATION_ID from PA_RESOURCE_LIST_MEMBERS.
FC_RES_TYPE_CODE	VARCHAR2	(30)	FC_RES_TYPE_CODE from PA_RESOURCE_LIST_MEMBERS.
EXPENDITURE_TYPE	VARCHAR2	(30)	EXPENDITURE_TYPE from PA_RESOURCE_LIST_MEMBERS.
EXPENDITURE_CATEGORY	VARCHAR2	(30)	EXPENDITURE_CATEGORY from PA_RESOURCE_LIST_MEMBERS.
EVENT_TYPE	VARCHAR2	(30)	EVENT_TYPE from PA_RESOURCE_LIST_MEMBERS.
REVENUE_CATEGORY	VARCHAR2	(30)	REVENUE_CATEGORY from PA_RESOURCE_LIST_MEMBERS.
VENDOR_ID	NUMBER	(15)	VENDOR_ID from PA_RESOURCE_LIST_MEMBERS.
SPREAD_CURVE_ID	NUMBER	(15)	SPREAD_CURVE_ID from PA_RESOURCE_LIST_MEMBERS.
ETC_METHOD_CODE	VARCHAR2	(30)	ETC_METHOD_CODE from PA_RESOURCE_LIST_MEMBERS.
MFC_COST_TYPE_ID	NUMBER	(15)	MFC_COST_TYPE_ID from PA_RESOURCE_LIST_MEMBERS.
INCURRED_BY_RES_FLAG	VARCHAR2	(1)	INCURRED_BY_RES_FLAG from PA_RESOURCE_LIST_MEMBERS.
INCUR_BY_RES_CLASS_CODE	VARCHAR2	(30)	INCUR_BY_RES_CLASS_CODE from PA_RESOURCE_LIST_MEMBERS.
INCUR_BY_ROLE_ID	NUMBER	(15)	INCUR_BY_ROLE_ID from PA_RESOURCE_LIST_MEMBERS.
UNIT_OF_MEASURE	VARCHAR2	(30)	UNIT_OF_MEASURE from PA_RESOURCE_LIST_MEMBERS.
ORG_ID	NUMBER	(15)	ORG_ID derived based on attributes of the planning resource.
RATE_BASED_FLAG	VARCHAR2	(1)	RATE_BASED_FLAG derived based on attributes of the planning resource.
RATE_EXPENDITURE_TYPE	VARCHAR2	(30)	RATE_EXPENDITURE_TYPE derived based on attributes of the planning resource.
RATE_FUNC_CURR_CODE	VARCHAR2	(30)	RATE_FUNC_CURR_CODE derived based on attributes of the planning resource.
RATE_INCURRED_BY_ORG_ID	NUMBER	(15)	RATE_INCURRED_BY_ORG_ID derived based on attributes of the planning resource.

Query Text

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


SELECT RESOURCE_LIST_MEMBER_ID
,      ORDER_ID
,      RESOURCE_CLASS_FLAG
,      RESOURCE_CLASS_CODE
,      RESOURCE_CLASS_ID
,      RES_TYPE_CODE
,      PERSON_ID
,      JOB_ID
,      PERSON_TYPE_CODE
,      NAMED_ROLE
,      BOM_RESOURCE_ID
,      NON_LABOR_RESOURCE
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      PROJECT_ROLE_ID
,      ORGANIZATION_ID
,      FC_RES_TYPE_CODE
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      EVENT_TYPE
,      REVENUE_CATEGORY
,      VENDOR_ID
,      SPREAD_CURVE_ID
,      ETC_METHOD_CODE
,      MFC_COST_TYPE_ID
,      INCURRED_BY_RES_FLAG
,      INCUR_BY_RES_CLASS_CODE
,      INCUR_BY_ROLE_ID
,      UNIT_OF_MEASURE
,      ORG_ID
,      RATE_BASED_FLAG
,      RATE_EXPENDITURE_TYPE
,      RATE_FUNC_CURR_CODE
,      RATE_INCURRED_BY_ORG_ID
FROM PA.PA_RES_MEMBERS_TEMP;

Dependencies

[top of page]

PA.PA_RES_MEMBERS_TEMP does not reference any database object

PA.PA_RES_MEMBERS_TEMP is referenced by following:

APPS: PA_RES_MEMBERS_TEMP