PJF_RBS_ELEMENTS_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

RBS_ELEMENT_ID RBS_ELEMENT_NAME_ID RBS_VERSION_ID OUTLINE_NUMBER ORDER_NUMBER RESOURCE_TYPE_ID RESOURCE_SOURCE_ID ALIAS ENABLED_FLAG RES_FORMAT_ID RESOURCE_CLASS_CODE SPREAD_CURVE_ID MFC_COST_TYPE_ID UNIT_OF_MEASURE PERSON_ID JOB_ID ORGANIZATION_ID EXPENDITURE_TYPE_ID EVENT_TYPE_ID EXPENDITURE_CATEGORY_ID REVENUE_CATEGORY_ID INVENTORY_ITEM_ID ITEM_CATEGORY_ID NON_LABOR_RESOURCE_ID ROLE_ID PERSON_TYPE_ID RESOURCE_CLASS_ID VENDOR_ID BOM_LABOR_ID BOM_EQUIPMENT_ID RULE_FLAG PARENT_ELEMENT_ID RBS_LEVEL LEAF_NODE_FLAG 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 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 MARKED_FOR LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Query

SQL_Statement

SELECT B.RBS_ELEMENT_ID RBS_ELEMENT_ID, B.RBS_ELEMENT_NAME_ID RBS_ELEMENT_NAME_ID, B.RBS_VERSION_ID RBS_VERSION_ID, B.OUTLINE_NUMBER OUTLINE_NUMBER, B.ORDER_NUMBER ORDER_NUMBER, B.RESOURCE_TYPE_ID RESOURCE_TYPE_ID, B.RESOURCE_SOURCE_ID RESOURCE_SOURCE_ID, NVL(TL.ALIAS,B.ALIAS) ALIAS, B.ENABLED_FLAG ENABLED_FLAG, B.RES_FORMAT_ID RES_FORMAT_ID, B.RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, B.SPREAD_CURVE_ID SPREAD_CURVE_ID, B.MFC_COST_TYPE_ID MFC_COST_TYPE_ID, B.UNIT_OF_MEASURE UNIT_OF_MEASURE, B.PERSON_ID PERSON_ID, B.JOB_ID JOB_ID, B.ORGANIZATION_ID ORGANIZATION_ID, B.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, B.EVENT_TYPE_ID EVENT_TYPE_ID, B.EXPENDITURE_CATEGORY_ID EXPENDITURE_CATEGORY_ID, B.REVENUE_CATEGORY_ID REVENUE_CATEGORY_ID, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, B.ITEM_CATEGORY_ID ITEM_CATEGORY_ID, B.NON_LABOR_RESOURCE_ID NON_LABOR_RESOURCE_ID, B.ROLE_ID ROLE_ID, B.PERSON_TYPE_ID PERSON_TYPE_ID, B.RESOURCE_CLASS_ID RESOURCE_CLASS_ID, B.VENDOR_ID VENDOR_ID, B.BOM_LABOR_ID BOM_LABOR_ID, B.BOM_EQUIPMENT_ID BOM_EQUIPMENT_ID, B.RULE_FLAG RULE_FLAG, B.PARENT_ELEMENT_ID PARENT_ELEMENT_ID, B.RBS_LEVEL RBS_LEVEL, B.LEAF_NODE_FLAG LEAF_NODE_FLAG, B.ELEMENT_IDENTIFIER ELEMENT_IDENTIFIER, B.USER_DEFINED_CUSTOM1_ID USER_DEFINED_CUSTOM1_ID, B.USER_DEFINED_CUSTOM2_ID USER_DEFINED_CUSTOM2_ID, B.USER_DEFINED_CUSTOM3_ID USER_DEFINED_CUSTOM3_ID, B.USER_DEFINED_CUSTOM4_ID USER_DEFINED_CUSTOM4_ID, B.USER_DEFINED_CUSTOM5_ID USER_DEFINED_CUSTOM5_ID, B.USER_CREATED_FLAG USER_CREATED_FLAG, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE6 ATTRIBUTE6, B.ATTRIBUTE7 ATTRIBUTE7, B.ATTRIBUTE8 ATTRIBUTE8, B.ATTRIBUTE9 ATTRIBUTE9, B.ATTRIBUTE10 ATTRIBUTE10, B.ATTRIBUTE11 ATTRIBUTE11, B.ATTRIBUTE12 ATTRIBUTE12, B.ATTRIBUTE13 ATTRIBUTE13, B.ATTRIBUTE14 ATTRIBUTE14, B.ATTRIBUTE15 ATTRIBUTE15, B.ATTRIBUTE16 ATTRIBUTE16, B.ATTRIBUTE17 ATTRIBUTE17, B.ATTRIBUTE18 ATTRIBUTE18, B.ATTRIBUTE19 ATTRIBUTE19, B.ATTRIBUTE20 ATTRIBUTE20, B.ATTRIBUTE21 ATTRIBUTE21, B.ATTRIBUTE22 ATTRIBUTE22, B.ATTRIBUTE23 ATTRIBUTE23, B.ATTRIBUTE24 ATTRIBUTE24, B.ATTRIBUTE25 ATTRIBUTE25, B.ATTRIBUTE26 ATTRIBUTE26, B.ATTRIBUTE27 ATTRIBUTE27, B.ATTRIBUTE28 ATTRIBUTE28, B.ATTRIBUTE29 ATTRIBUTE29, B.ATTRIBUTE30 ATTRIBUTE30, B.MARKED_FOR MARKED_FOR, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.REQUEST_ID REQUEST_ID, B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM pjf_rbs_elements B, pjf_rbs_elements_tl TL WHERE B.rbs_element_id = TL.rbs_element_id (+) AND B.rbs_version_id = TL.rbs_version_id (+) AND TL.language (+) = USERENV('lang')