DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_RBS_MAP_TMP9

Object Details
Object Name: PA_RBS_MAP_TMP9
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Temporary Table Details

PA.PA_RBS_MAP_TMP9 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: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
TXN_ACCUM_HEADER_ID NUMBER (15)
Transaction accum indentifier
STRUCT_VERSION_ID NUMBER (15)
RBS definition Identifier
ELEMENT_VERSION_ID NUMBER (15)
RBS Element identifier
PARENT_ELEMENT_VERSION_ID NUMBER (15)
RBS parent element identifier
SEQUENCE NUMBER (15)
Identifier for the RBS element version sequence
RESOURCE_CLASS_ID NUMBER (15)
Identifier for the resource class
BOM_LABOR_ID NUMBER (15)
Identifier for the BOM resource - labor resource type
BOM_EQUIPMENT_ID NUMBER (15)
Identifier for the BOM resource - Equipment resource type
PERSON_ID NUMBER (15)
Identifier for the person whose resource type is Named person
EVENT_TYPE_ID NUMBER (15)
Identifier for the event type
EXPENDITURE_CATEGORY_ID NUMBER (15)
Identifier for the expenditure category
EXPENDITURE_TYPE_ID NUMBER (15)
Identifier for the expenditure type
ITEM_CATEGORY_ID NUMBER (15)
Identifier for the inventory item category
INVENTORY_ITEM_ID NUMBER (15)
Identifier for the inventory item
JOB_ID NUMBER (15)
Identifier for the Job
ORGANIZATION_ID NUMBER (15)
Identifier for the organization
PERSON_TYPE_ID NUMBER (15)
Identifier for the person type
NON_LABOR_RESOURCE_ID NUMBER (15)
Identifier for the projects non-labor resources
REVENUE_CATEGORY_ID NUMBER (15)
Identifier for the revenue category
ROLE_ID NUMBER (15)
Identifier for the project role
SUPPLIER_ID NUMBER (15)
Identifier for the vendor (supplier)
USER_DEFINED_CUSTOM1_ID NUMBER (15)
Identifier for the user defined resource 1
USER_DEFINED_CUSTOM2_ID NUMBER (15)
Identifier for the user defined resource 2
USER_DEFINED_CUSTOM3_ID NUMBER (15)
Identifier for the user defined resource 3
USER_DEFINED_CUSTOM4_ID NUMBER (15)
Identifier for the user defined resource 4
USER_DEFINED_CUSTOM5_ID NUMBER (15)
Identifier for the user defined resource 5
RESOURCE_TYPE_ID NUMBER (15)
Identifier for the resource type
RESOURCE_SOURCE_ID NUMBER (15)
Identifier for the resource source
Query Text

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


SELECT TXN_ACCUM_HEADER_ID
,      STRUCT_VERSION_ID
,      ELEMENT_VERSION_ID
,      PARENT_ELEMENT_VERSION_ID
,      SEQUENCE
,      RESOURCE_CLASS_ID
,      BOM_LABOR_ID
,      BOM_EQUIPMENT_ID
,      PERSON_ID
,      EVENT_TYPE_ID
,      EXPENDITURE_CATEGORY_ID
,      EXPENDITURE_TYPE_ID
,      ITEM_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      JOB_ID
,      ORGANIZATION_ID
,      PERSON_TYPE_ID
,      NON_LABOR_RESOURCE_ID
,      REVENUE_CATEGORY_ID
,      ROLE_ID
,      SUPPLIER_ID
,      USER_DEFINED_CUSTOM1_ID
,      USER_DEFINED_CUSTOM2_ID
,      USER_DEFINED_CUSTOM3_ID
,      USER_DEFINED_CUSTOM4_ID
,      USER_DEFINED_CUSTOM5_ID
,      RESOURCE_TYPE_ID
,      RESOURCE_SOURCE_ID
FROM PA.PA_RBS_MAP_TMP9;

Dependencies

[top of page]

PA.PA_RBS_MAP_TMP9 does not reference any database object

PA.PA_RBS_MAP_TMP9 is referenced by following:

SchemaAPPS
SynonymPA_RBS_MAP_TMP9