VIEW: APPS.FEM_DIS_USR_DIM9_HIER_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.OBJECT_ID, B.OBJECT_DEFINITION_ID, B.VALUE_SET_ID, B.LEVEL1_ID, B.LEVEL2_ID, B.LEVEL3_ID, B.LEVEL4_ID, B.LEVEL5_ID, B.LEVEL6_ID, B.LEVEL7_ID, B.LEVEL8_ID, B.LEVEL9_ID, B.LEVEL10_ID, B.LEVEL11_ID, B.LEVEL12_ID, B.LEVEL13_ID, B.LEVEL14_ID, B.LEVEL15_ID, B.LEVEL16_ID, B.LEVEL17_ID, B.LEVEL18_ID, B.LEVEL19_ID, B.LEVEL20_ID, B.LEVEL1_DISPLAY_CODE, B.LEVEL2_DISPLAY_CODE, B.LEVEL3_DISPLAY_CODE, B.LEVEL4_DISPLAY_CODE, B.LEVEL5_DISPLAY_CODE, B.LEVEL6_DISPLAY_CODE, B.LEVEL7_DISPLAY_CODE, B.LEVEL8_DISPLAY_CODE, B.LEVEL9_DISPLAY_CODE, B.LEVEL10_DISPLAY_CODE, B.LEVEL11_DISPLAY_CODE, B.LEVEL12_DISPLAY_CODE, B.LEVEL13_DISPLAY_CODE, B.LEVEL14_DISPLAY_CODE, B.LEVEL15_DISPLAY_CODE, B.LEVEL16_DISPLAY_CODE, B.LEVEL17_DISPLAY_CODE, B.LEVEL18_DISPLAY_CODE, B.LEVEL19_DISPLAY_CODE, B.LEVEL20_DISPLAY_CODE, B.LEVEL1_DISPLAY_ORDER_NUM, B.LEVEL2_DISPLAY_ORDER_NUM, B.LEVEL3_DISPLAY_ORDER_NUM, B.LEVEL4_DISPLAY_ORDER_NUM, B.LEVEL5_DISPLAY_ORDER_NUM, B.LEVEL6_DISPLAY_ORDER_NUM, B.LEVEL7_DISPLAY_ORDER_NUM, B.LEVEL8_DISPLAY_ORDER_NUM, B.LEVEL9_DISPLAY_ORDER_NUM, B.LEVEL10_DISPLAY_ORDER_NUM, B.LEVEL11_DISPLAY_ORDER_NUM, B.LEVEL12_DISPLAY_ORDER_NUM, B.LEVEL13_DISPLAY_ORDER_NUM, B.LEVEL14_DISPLAY_ORDER_NUM, B.LEVEL15_DISPLAY_ORDER_NUM, B.LEVEL16_DISPLAY_ORDER_NUM, B.LEVEL17_DISPLAY_ORDER_NUM, B.LEVEL18_DISPLAY_ORDER_NUM, B.LEVEL19_DISPLAY_ORDER_NUM, B.LEVEL20_DISPLAY_ORDER_NUM, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, TL.OBJECT_NAME, TL.OBJECT_DEFINITION_NAME, TL.LEVEL1_NAME, TL.LEVEL2_NAME, TL.LEVEL3_NAME, TL.LEVEL4_NAME, TL.LEVEL5_NAME, TL.LEVEL6_NAME, TL.LEVEL7_NAME, TL.LEVEL8_NAME, TL.LEVEL9_NAME, TL.LEVEL10_NAME, TL.LEVEL11_NAME, TL.LEVEL12_NAME, TL.LEVEL13_NAME, TL.LEVEL14_NAME, TL.LEVEL15_NAME, TL.LEVEL16_NAME, TL.LEVEL17_NAME, TL.LEVEL18_NAME, TL.LEVEL19_NAME, TL.LEVEL20_NAME, TL.LEVEL1_DESCRIPTION, TL.LEVEL2_DESCRIPTION, TL.LEVEL3_DESCRIPTION, TL.LEVEL4_DESCRIPTION, TL.LEVEL5_DESCRIPTION, TL.LEVEL6_DESCRIPTION, TL.LEVEL7_DESCRIPTION, TL.LEVEL8_DESCRIPTION, TL.LEVEL9_DESCRIPTION, TL.LEVEL10_DESCRIPTION, TL.LEVEL11_DESCRIPTION, TL.LEVEL12_DESCRIPTION, TL.LEVEL13_DESCRIPTION, TL.LEVEL14_DESCRIPTION, TL.LEVEL15_DESCRIPTION, TL.LEVEL16_DESCRIPTION, TL.LEVEL17_DESCRIPTION, TL.LEVEL18_DESCRIPTION, TL.LEVEL19_DESCRIPTION, TL.LEVEL20_DESCRIPTION FROM FEM_DIS_USR_DIM9_HIER_B B, FEM_DIS_USR_DIM9_HIER_TL TL WHERE B.OBJECT_ID = TL.OBJECT_ID AND B.OBJECT_DEFINITION_ID = TL.OBJECT_DEFINITION_ID AND B.VALUE_SET_ID = TL.VALUE_SET_ID AND B.LEVEL1_ID = TL.LEVEL1_ID AND B.LEVEL2_ID = TL.LEVEL2_ID AND B.LEVEL3_ID = TL.LEVEL3_ID AND B.LEVEL4_ID = TL.LEVEL4_ID AND B.LEVEL5_ID = TL.LEVEL5_ID AND B.LEVEL6_ID = TL.LEVEL6_ID AND B.LEVEL7_ID = TL.LEVEL7_ID AND B.LEVEL8_ID = TL.LEVEL8_ID AND B.LEVEL9_ID = TL.LEVEL9_ID AND B.LEVEL10_ID = TL.LEVEL10_ID AND B.LEVEL11_ID = TL.LEVEL11_ID AND B.LEVEL12_ID = TL.LEVEL12_ID AND B.LEVEL13_ID = TL.LEVEL13_ID AND B.LEVEL14_ID = TL.LEVEL14_ID AND B.LEVEL15_ID = TL.LEVEL15_ID AND B.LEVEL16_ID = TL.LEVEL16_ID AND B.LEVEL17_ID = TL.LEVEL17_ID AND B.LEVEL18_ID = TL.LEVEL18_ID AND B.LEVEL19_ID = TL.LEVEL19_ID AND B.LEVEL20_ID = TL.LEVEL20_ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.OBJECT_ID
, B.OBJECT_DEFINITION_ID
, B.VALUE_SET_ID
, B.LEVEL1_ID
, B.LEVEL2_ID
, B.LEVEL3_ID
, B.LEVEL4_ID
, B.LEVEL5_ID
, B.LEVEL6_ID
, B.LEVEL7_ID
, B.LEVEL8_ID
, B.LEVEL9_ID
, B.LEVEL10_ID
, B.LEVEL11_ID
, B.LEVEL12_ID
, B.LEVEL13_ID
, B.LEVEL14_ID
, B.LEVEL15_ID
, B.LEVEL16_ID
, B.LEVEL17_ID
, B.LEVEL18_ID
, B.LEVEL19_ID
, B.LEVEL20_ID
, B.LEVEL1_DISPLAY_CODE
, B.LEVEL2_DISPLAY_CODE
, B.LEVEL3_DISPLAY_CODE
, B.LEVEL4_DISPLAY_CODE
, B.LEVEL5_DISPLAY_CODE
, B.LEVEL6_DISPLAY_CODE
, B.LEVEL7_DISPLAY_CODE
, B.LEVEL8_DISPLAY_CODE
, B.LEVEL9_DISPLAY_CODE
, B.LEVEL10_DISPLAY_CODE
, B.LEVEL11_DISPLAY_CODE
, B.LEVEL12_DISPLAY_CODE
, B.LEVEL13_DISPLAY_CODE
, B.LEVEL14_DISPLAY_CODE
, B.LEVEL15_DISPLAY_CODE
, B.LEVEL16_DISPLAY_CODE
, B.LEVEL17_DISPLAY_CODE
, B.LEVEL18_DISPLAY_CODE
, B.LEVEL19_DISPLAY_CODE
, B.LEVEL20_DISPLAY_CODE
, B.LEVEL1_DISPLAY_ORDER_NUM
, B.LEVEL2_DISPLAY_ORDER_NUM
, B.LEVEL3_DISPLAY_ORDER_NUM
, B.LEVEL4_DISPLAY_ORDER_NUM
, B.LEVEL5_DISPLAY_ORDER_NUM
, B.LEVEL6_DISPLAY_ORDER_NUM
, B.LEVEL7_DISPLAY_ORDER_NUM
, B.LEVEL8_DISPLAY_ORDER_NUM
, B.LEVEL9_DISPLAY_ORDER_NUM
, B.LEVEL10_DISPLAY_ORDER_NUM
, B.LEVEL11_DISPLAY_ORDER_NUM
, B.LEVEL12_DISPLAY_ORDER_NUM
, B.LEVEL13_DISPLAY_ORDER_NUM
, B.LEVEL14_DISPLAY_ORDER_NUM
, B.LEVEL15_DISPLAY_ORDER_NUM
, B.LEVEL16_DISPLAY_ORDER_NUM
, B.LEVEL17_DISPLAY_ORDER_NUM
, B.LEVEL18_DISPLAY_ORDER_NUM
, B.LEVEL19_DISPLAY_ORDER_NUM
, B.LEVEL20_DISPLAY_ORDER_NUM
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, TL.OBJECT_NAME
, TL.OBJECT_DEFINITION_NAME
, TL.LEVEL1_NAME
, TL.LEVEL2_NAME
, TL.LEVEL3_NAME
, TL.LEVEL4_NAME
, TL.LEVEL5_NAME
, TL.LEVEL6_NAME
, TL.LEVEL7_NAME
, TL.LEVEL8_NAME
, TL.LEVEL9_NAME
, TL.LEVEL10_NAME
, TL.LEVEL11_NAME
, TL.LEVEL12_NAME
, TL.LEVEL13_NAME
, TL.LEVEL14_NAME
, TL.LEVEL15_NAME
, TL.LEVEL16_NAME
, TL.LEVEL17_NAME
, TL.LEVEL18_NAME
, TL.LEVEL19_NAME
, TL.LEVEL20_NAME
, TL.LEVEL1_DESCRIPTION
, TL.LEVEL2_DESCRIPTION
, TL.LEVEL3_DESCRIPTION
, TL.LEVEL4_DESCRIPTION
, TL.LEVEL5_DESCRIPTION
, TL.LEVEL6_DESCRIPTION
, TL.LEVEL7_DESCRIPTION
, TL.LEVEL8_DESCRIPTION
, TL.LEVEL9_DESCRIPTION
, TL.LEVEL10_DESCRIPTION
, TL.LEVEL11_DESCRIPTION
, TL.LEVEL12_DESCRIPTION
, TL.LEVEL13_DESCRIPTION
, TL.LEVEL14_DESCRIPTION
, TL.LEVEL15_DESCRIPTION
, TL.LEVEL16_DESCRIPTION
, TL.LEVEL17_DESCRIPTION
, TL.LEVEL18_DESCRIPTION
, TL.LEVEL19_DESCRIPTION
, TL.LEVEL20_DESCRIPTION
FROM FEM_DIS_USR_DIM9_HIER_B B
, FEM_DIS_USR_DIM9_HIER_TL TL
WHERE B.OBJECT_ID = TL.OBJECT_ID
AND B.OBJECT_DEFINITION_ID = TL.OBJECT_DEFINITION_ID
AND B.VALUE_SET_ID = TL.VALUE_SET_ID
AND B.LEVEL1_ID = TL.LEVEL1_ID
AND B.LEVEL2_ID = TL.LEVEL2_ID
AND B.LEVEL3_ID = TL.LEVEL3_ID
AND B.LEVEL4_ID = TL.LEVEL4_ID
AND B.LEVEL5_ID = TL.LEVEL5_ID
AND B.LEVEL6_ID = TL.LEVEL6_ID
AND B.LEVEL7_ID = TL.LEVEL7_ID
AND B.LEVEL8_ID = TL.LEVEL8_ID
AND B.LEVEL9_ID = TL.LEVEL9_ID
AND B.LEVEL10_ID = TL.LEVEL10_ID
AND B.LEVEL11_ID = TL.LEVEL11_ID
AND B.LEVEL12_ID = TL.LEVEL12_ID
AND B.LEVEL13_ID = TL.LEVEL13_ID
AND B.LEVEL14_ID = TL.LEVEL14_ID
AND B.LEVEL15_ID = TL.LEVEL15_ID
AND B.LEVEL16_ID = TL.LEVEL16_ID
AND B.LEVEL17_ID = TL.LEVEL17_ID
AND B.LEVEL18_ID = TL.LEVEL18_ID
AND B.LEVEL19_ID = TL.LEVEL19_ID
AND B.LEVEL20_ID = TL.LEVEL20_ID
AND TL.LANGUAGE = USERENV('LANG')