CST_COST_ELEMENT_GRPS_VL

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

GROUP_ID OBJECT_VERSION_NUMBER GROUP_CODE COST_ORGANIZATION_ID INACTIVE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY IS_SEED ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 GROUP_DESC

Query

SQL_Statement

SELECT CST_COST_ELEMENT_GRPS_B.GROUP_ID GROUP_ID, CST_COST_ELEMENT_GRPS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CST_COST_ELEMENT_GRPS_B.GROUP_CODE GROUP_CODE, CST_COST_ELEMENT_GRPS_B.COST_ORGANIZATION_ID COST_ORGANIZATION_ID, CST_COST_ELEMENT_GRPS_B.INACTIVE_FLAG INACTIVE_FLAG, CST_COST_ELEMENT_GRPS_B.CREATED_BY CREATED_BY, CST_COST_ELEMENT_GRPS_B.CREATION_DATE CREATION_DATE, CST_COST_ELEMENT_GRPS_B.LAST_UPDATED_BY LAST_UPDATED_BY, CST_COST_ELEMENT_GRPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CST_COST_ELEMENT_GRPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CST_COST_ELEMENT_GRPS_B.IS_SEED IS_SEED, CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR1 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR2 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR3 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR4 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR5 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR6 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR7 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR8 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR9 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR10 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR11 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR12 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR13 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR14 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR15 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR16 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR17 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR18 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR19 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_CHAR20 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER1 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER2 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER3 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER4 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER5 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER6 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER7 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER8 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER9 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_NUMBER10 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_DATE1 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_DATE2 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_DATE3 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_DATE4 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_DATE5 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_TIMESTAMP1 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_TIMESTAMP2 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_TIMESTAMP3 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_TIMESTAMP4 , CST_COST_ELEMENT_GRPS_B.ATTRIBUTE_TIMESTAMP5 , CST_COST_ELEMENT_GRPS_TL.GROUP_DESC GROUP_DESC FROM CST_COST_ELEMENT_GRPS_B, CST_COST_ELEMENT_GRPS_TL WHERE CST_COST_ELEMENT_GRPS_B.GROUP_ID = CST_COST_ELEMENT_GRPS_TL.GROUP_ID AND CST_COST_ELEMENT_GRPS_TL.LANGUAGE = USERENV('LANG')