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

VIEW: PA.PA_RBS_ELEMENTS#

Object Details
Object Name: PA_RBS_ELEMENTS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RBS_ELEMENT_ID NUMBER (15) Yes
RBS_ELEMENT_NAME_ID NUMBER (15) Yes
RBS_VERSION_ID NUMBER (15) Yes
OUTLINE_NUMBER VARCHAR2 (240) Yes
ORDER_NUMBER NUMBER (15)
RESOURCE_TYPE_ID NUMBER (15) Yes
RESOURCE_SOURCE_ID NUMBER (15)
PERSON_ID NUMBER (15)
JOB_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
EXPENDITURE_TYPE_ID NUMBER (15)
EVENT_TYPE_ID NUMBER (15)
EXPENDITURE_CATEGORY_ID NUMBER (15)
REVENUE_CATEGORY_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
ITEM_CATEGORY_ID NUMBER (15)
BOM_LABOR_ID NUMBER (15)
BOM_EQUIPMENT_ID NUMBER (15)
NON_LABOR_RESOURCE_ID NUMBER (15)
ROLE_ID NUMBER (15)
PERSON_TYPE_ID NUMBER (15)
RESOURCE_CLASS_ID NUMBER (15)
SUPPLIER_ID NUMBER (15)
RULE_FLAG VARCHAR2 (1) Yes
PARENT_ELEMENT_ID NUMBER (15)
RBS_LEVEL NUMBER (15) Yes
ELEMENT_IDENTIFIER NUMBER (15) Yes
USER_DEFINED_CUSTOM1_ID NUMBER (15)
USER_DEFINED_CUSTOM2_ID NUMBER (15)
USER_DEFINED_CUSTOM3_ID NUMBER (15)
USER_DEFINED_CUSTOM4_ID NUMBER (15)
USER_DEFINED_CUSTOM5_ID NUMBER (15)
USER_CREATED_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
RECORD_VERSION_NUMBER NUMBER (15) Yes
LEVEL_CODE VARCHAR2 (20)
COST_CODE VARCHAR2 (250)
ENABLE_FLAG VARCHAR2 (1)
COST_CODE_NAME VARCHAR2 (240)
CONNECT_PATH VARCHAR2 (240)
LEAF_NODE NUMBER

Query Text

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


SELECT RBS_ELEMENT_ID
,      RBS_ELEMENT_NAME_ID
,      RBS_VERSION_ID
,      OUTLINE_NUMBER
,      ORDER_NUMBER
,      RESOURCE_TYPE_ID
,      RESOURCE_SOURCE_ID
,      PERSON_ID
,      JOB_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE_ID
,      EVENT_TYPE_ID
,      EXPENDITURE_CATEGORY_ID
,      REVENUE_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      BOM_LABOR_ID
,      BOM_EQUIPMENT_ID
,      NON_LABOR_RESOURCE_ID
,      ROLE_ID
,      PERSON_TYPE_ID
,      RESOURCE_CLASS_ID
,      SUPPLIER_ID
,      RULE_FLAG
,      PARENT_ELEMENT_ID
,      RBS_LEVEL
,      ELEMENT_IDENTIFIER
,      USER_DEFINED_CUSTOM1_ID
,      USER_DEFINED_CUSTOM2_ID
,      USER_DEFINED_CUSTOM3_ID
,      USER_DEFINED_CUSTOM4_ID
,      USER_DEFINED_CUSTOM5_ID
,      USER_CREATED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
,      LEVEL_CODE
,      COST_CODE
,      ENABLE_FLAG
,      COST_CODE_NAME
,      CONNECT_PATH
,      LEAF_NODE
FROM PA.PA_RBS_ELEMENTS#;

Dependencies

[top of page]

PA.PA_RBS_ELEMENTS# references the following:

SchemaPA
TablePA_RBS_ELEMENTS
PA.PA_RBS_ELEMENTS# is referenced by following:

SchemaAPPS
SynonymPA_RBS_ELEMENTS