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

TABLE: PA.PA_RBS_PLANS_IN_TMP

Object Details
Object Name: PA_RBS_PLANS_IN_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_IN_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
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)
The revenue category code, if RBS element is a revenue category.
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)
The person type code, if RBS element is a person type.
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.
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.
Query Text

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


SELECT 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
,      SOURCE_ID
,      TXN_ACCUM_HEADER_ID
,      NAMED_ROLE
FROM PA.PA_RBS_PLANS_IN_TMP;

Dependencies

[top of page]

PA.PA_RBS_PLANS_IN_TMP does not reference any database object

PA.PA_RBS_PLANS_IN_TMP is referenced by following:

SchemaAPPS
SynonymPA_RBS_PLANS_IN_TMP