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.

[Home] [Help]

VIEW: PA.PA_RBS_ELEMENTS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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