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

TABLE: PA.PA_RBS_PLANS_OUT_TMP

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

This table stores the RBS element information and the parent-child
relationship.

Temporary Table Details

PA.PA_RBS_PLANS_OUT_TMP 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
RBS_ELEMENT_ID NUMBER (15)
Unique identifier of the RBS element.
RBS_ELEMENT_NAME_ID NUMBER (15)
Foreign key to the denormalized name table.
RBS_VERSION_ID NUMBER (15)
Identifier of the RBS version to which the element belongs.
PERSON_ID NUMBER (15)
The person ID of the element, if RBS element is a person.
JOB_ID NUMBER (15)
The job ID of the element, if RBS element is a job.
ORGANIZATION_ID NUMBER (15)
The organization ID of the element, if RBS element is a organization.
EXPENDITURE_TYPE_ID NUMBER (15)
The expenditure type ID, if RBS element is an expenditure type.
EVENT_TYPE_ID NUMBER (15)
The event type ID, if RBS element is an event type.
EXPENDITURE_CATEGORY_ID NUMBER (15)
The expenditure category ID, if RBS element is an expenditure category.
REVENUE_CATEGORY_CODE VARCHAR2 (30)
Revenue Category Code
INVENTORY_ITEM_ID NUMBER (15)
The item ID of the element, if RBS element is an item.
ITEM_CATEGORY_ID NUMBER (15)
The item category ID of the element, if RBS element is an item category.
BOM_LABOR_ID NUMBER (15)
The BOM Resource ID of the element, if RBS element is a BOM Labor resource.
BOM_EQUIPMENT_ID NUMBER (15)
The BOM Resource ID of the element, if RBS element is a BOM Equipment resource.
NON_LABOR_RESOURCE_ID NUMBER (15)
The Non-labor Resource ID of the element, if RBS element is a PA Non-Labor resource.
ROLE_ID NUMBER (15)
The role ID of the element, if RBS element is a role.
PERSON_TYPE_CODE VARCHAR2 (30)
Person Type Code
RESOURCE_CLASS_ID NUMBER (15)
The resource class ID of the element, if RBS element is a resource class.
SUPPLIER_ID NUMBER (15)
The supplier ID of the element, if RBS element is a supplier.
PARENT_ELEMENT_ID NUMBER (15)
The parent element of the RBS element null for the top node..
SOURCE_ID NUMBER (15)
This is identifier for transaction.
TXN_ACCUM_HEADER_ID NUMBER (15)
This is identifier for header.
NAMED_ROLE VARCHAR2 (80)
This is identifier for named role.
REVENUE_CATEGORY_ID NUMBER

Identifier for Revenue Category Code
PERSON_TYPE_ID NUMBER

Identifier for Person Type Code
Query Text

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


SELECT RBS_ELEMENT_ID
,      RBS_ELEMENT_NAME_ID
,      RBS_VERSION_ID
,      PERSON_ID
,      JOB_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE_ID
,      EVENT_TYPE_ID
,      EXPENDITURE_CATEGORY_ID
,      REVENUE_CATEGORY_CODE
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      BOM_LABOR_ID
,      BOM_EQUIPMENT_ID
,      NON_LABOR_RESOURCE_ID
,      ROLE_ID
,      PERSON_TYPE_CODE
,      RESOURCE_CLASS_ID
,      SUPPLIER_ID
,      PARENT_ELEMENT_ID
,      SOURCE_ID
,      TXN_ACCUM_HEADER_ID
,      NAMED_ROLE
,      REVENUE_CATEGORY_ID
,      PERSON_TYPE_ID
FROM PA.PA_RBS_PLANS_OUT_TMP;

Dependencies

[top of page]

PA.PA_RBS_PLANS_OUT_TMP does not reference any database object

PA.PA_RBS_PLANS_OUT_TMP is referenced by following:

SchemaAPPS
SynonymPA_RBS_PLANS_OUT_TMP