EGP_FLATTENED_VALID_CATS_VL
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: VIEW
Columns
Name |
---|
CATEGORY_SET_ID CATEGORY_ID PARENT_CATEGORY_ID1 PARENT_CATEGORY_ID2 PARENT_CATEGORY_ID3 PARENT_CATEGORY_ID4 PARENT_CATEGORY_ID5 PARENT_CATEGORY_ID6 PARENT_CATEGORY_ID7 PARENT_CATEGORY_ID8 PARENT_CATEGORY_ID9 PARENT_CATEGORY_ID10 PARENT_CATEGORY_ID11 PARENT_CATEGORY_ID12 PARENT_CATEGORY_ID13 PARENT_CATEGORY_ID14 PARENT_CATEGORY_ID15 CATALOG_CODE PUBLIC_CATALOG CATEGORY_CODE PARENT_CATEGORY_CODE1 PARENT_CATEGORY_CODE2 PARENT_CATEGORY_CODE3 PARENT_CATEGORY_CODE4 PARENT_CATEGORY_CODE5 PARENT_CATEGORY_CODE6 PARENT_CATEGORY_CODE7 PARENT_CATEGORY_CODE8 PARENT_CATEGORY_CODE9 PARENT_CATEGORY_CODE10 PARENT_CATEGORY_CODE11 PARENT_CATEGORY_CODE12 PARENT_CATEGORY_CODE13 PARENT_CATEGORY_CODE14 PARENT_CATEGORY_CODE15 CATALOG_NAME CATEGORY_NAME PARENT_CATEGORY_NAME1 PARENT_CATEGORY_NAME2 PARENT_CATEGORY_NAME3 PARENT_CATEGORY_NAME4 PARENT_CATEGORY_NAME5 PARENT_CATEGORY_NAME6 PARENT_CATEGORY_NAME7 PARENT_CATEGORY_NAME8 PARENT_CATEGORY_NAME9 PARENT_CATEGORY_NAME10 PARENT_CATEGORY_NAME11 PARENT_CATEGORY_NAME12 PARENT_CATEGORY_NAME13 PARENT_CATEGORY_NAME14 PARENT_CATEGORY_NAME15 CATALOG_DESCRIPTION CATEGORY_DESCRIPTION PARENT_CATEGORY_DESCRIPTION1 PARENT_CATEGORY_DESCRIPTION2 PARENT_CATEGORY_DESCRIPTION3 PARENT_CATEGORY_DESCRIPTION4 PARENT_CATEGORY_DESCRIPTION5 PARENT_CATEGORY_DESCRIPTION6 PARENT_CATEGORY_DESCRIPTION7 PARENT_CATEGORY_DESCRIPTION8 PARENT_CATEGORY_DESCRIPTION9 PARENT_CATEGORY_DESCRIPTION10 PARENT_CATEGORY_DESCRIPTION11 PARENT_CATEGORY_DESCRIPTION12 PARENT_CATEGORY_DESCRIPTION13 PARENT_CATEGORY_DESCRIPTION14 PARENT_CATEGORY_DESCRIPTION15 CATEGORY_SHARED_FLAG PARENT_CATEGORY_ID REFERENCE_CATEGORY_SET_ID CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT FULL_CATEGORY_LIST.CATEGORY_SET_ID CATEGORY_SET_ID, FULL_CATEGORY_LIST.CATEGORY_ID CATEGORY_ID, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID1 PARENT_CATEGORY_ID1, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID2 PARENT_CATEGORY_ID2, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID3 PARENT_CATEGORY_ID3, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID4 PARENT_CATEGORY_ID4, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID5 PARENT_CATEGORY_ID5, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID6 PARENT_CATEGORY_ID6, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID7 PARENT_CATEGORY_ID7, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID8 PARENT_CATEGORY_ID8, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID9 PARENT_CATEGORY_ID9, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID10 PARENT_CATEGORY_ID10, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID11 PARENT_CATEGORY_ID11, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID12 PARENT_CATEGORY_ID12, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID13 PARENT_CATEGORY_ID13, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID14 PARENT_CATEGORY_ID14, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID15 PARENT_CATEGORY_ID15, CATALOG_B.CATALOG_CODE CATALOG_CODE, CATALOG_B.PUBLIC_CATALOG PUBLIC_CATALOG, CATEGORY_B.CATEGORY_CODE CATEGORY_CODE, PARENT_CATEGORY1_B.CATEGORY_CODE PARENT_CATEGORY_CODE1, PARENT_CATEGORY2_B.CATEGORY_CODE PARENT_CATEGORY_CODE2, PARENT_CATEGORY3_B.CATEGORY_CODE PARENT_CATEGORY_CODE3, PARENT_CATEGORY4_B.CATEGORY_CODE PARENT_CATEGORY_CODE4, PARENT_CATEGORY5_B.CATEGORY_CODE PARENT_CATEGORY_CODE5, PARENT_CATEGORY6_B.CATEGORY_CODE PARENT_CATEGORY_CODE6, PARENT_CATEGORY7_B.CATEGORY_CODE PARENT_CATEGORY_CODE7, PARENT_CATEGORY8_B.CATEGORY_CODE PARENT_CATEGORY_CODE8, PARENT_CATEGORY9_B.CATEGORY_CODE PARENT_CATEGORY_CODE9, PARENT_CATEGORY10_B.CATEGORY_CODE PARENT_CATEGORY_CODE10, PARENT_CATEGORY11_B.CATEGORY_CODE PARENT_CATEGORY_CODE11, PARENT_CATEGORY12_B.CATEGORY_CODE PARENT_CATEGORY_CODE12, PARENT_CATEGORY13_B.CATEGORY_CODE PARENT_CATEGORY_CODE13, PARENT_CATEGORY14_B.CATEGORY_CODE PARENT_CATEGORY_CODE14, PARENT_CATEGORY15_B.CATEGORY_CODE PARENT_CATEGORY_CODE15, CATALOG_TL.CATEGORY_SET_NAME CATALOG_NAME, CATEGORY_TL.CATEGORY_NAME CATEGORY_NAME, PARENT_CATEGORY1_TL.CATEGORY_NAME PARENT_CATEGORY_NAME1, PARENT_CATEGORY2_TL.CATEGORY_NAME PARENT_CATEGORY_NAME2, PARENT_CATEGORY3_TL.CATEGORY_NAME PARENT_CATEGORY_NAME3, PARENT_CATEGORY4_TL.CATEGORY_NAME PARENT_CATEGORY_NAME4, PARENT_CATEGORY5_TL.CATEGORY_NAME PARENT_CATEGORY_NAME5, PARENT_CATEGORY6_TL.CATEGORY_NAME PARENT_CATEGORY_NAME6, PARENT_CATEGORY7_TL.CATEGORY_NAME PARENT_CATEGORY_NAME7, PARENT_CATEGORY8_TL.CATEGORY_NAME PARENT_CATEGORY_NAME8, PARENT_CATEGORY9_TL.CATEGORY_NAME PARENT_CATEGORY_NAME9, PARENT_CATEGORY10_TL.CATEGORY_NAME PARENT_CATEGORY_NAME10, PARENT_CATEGORY11_TL.CATEGORY_NAME PARENT_CATEGORY_NAME11, PARENT_CATEGORY12_TL.CATEGORY_NAME PARENT_CATEGORY_NAME12, PARENT_CATEGORY13_TL.CATEGORY_NAME PARENT_CATEGORY_NAME13, PARENT_CATEGORY14_TL.CATEGORY_NAME PARENT_CATEGORY_NAME14, PARENT_CATEGORY15_TL.CATEGORY_NAME PARENT_CATEGORY_NAME15, CATALOG_TL.DESCRIPTION CATALOG_DESCRIPTION, CATEGORY_TL.DESCRIPTION CATEGORY_DESCRIPTION, PARENT_CATEGORY1_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION1, PARENT_CATEGORY2_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION2, PARENT_CATEGORY3_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION3, PARENT_CATEGORY4_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION4, PARENT_CATEGORY5_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION5, PARENT_CATEGORY6_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION6, PARENT_CATEGORY7_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION7, PARENT_CATEGORY8_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION8, PARENT_CATEGORY9_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION9, PARENT_CATEGORY10_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION10, PARENT_CATEGORY11_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION11, PARENT_CATEGORY12_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION12, PARENT_CATEGORY13_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION13, PARENT_CATEGORY14_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION14, PARENT_CATEGORY15_TL.DESCRIPTION PARENT_CATEGORY_DESCRIPTION15, FULL_CATEGORY_LIST.CATEGORY_SHARED_FLAG CATEGORY_SHARED_FLAG, FULL_CATEGORY_LIST.PARENT_CATEGORY_ID PARENT_CATEGORY_ID, FULL_CATEGORY_LIST.REFERENCE_CATEGORY_SET_ID REFERENCE_CATEGORY_SET_ID, FULL_CATEGORY_LIST.CREATION_DATE, FULL_CATEGORY_LIST.CREATED_BY, FULL_CATEGORY_LIST.LAST_UPDATED_BY, FULL_CATEGORY_LIST.LAST_UPDATE_DATE, FULL_CATEGORY_LIST.LAST_UPDATE_LOGIN FROM EGP_CATEGORIES_B CATEGORY_B, EGP_CATEGORY_SETS_TL CATALOG_TL, EGP_CATEGORIES_TL CATEGORY_TL, EGP_CATEGORY_SETS_B CATALOG_B, EGP_FULL_CATEGORY_LIST FULL_CATEGORY_LIST, EGP_CATEGORIES_B PARENT_CATEGORY1_B, EGP_CATEGORIES_B PARENT_CATEGORY2_B, EGP_CATEGORIES_B PARENT_CATEGORY3_B, EGP_CATEGORIES_B PARENT_CATEGORY4_B, EGP_CATEGORIES_B PARENT_CATEGORY5_B, EGP_CATEGORIES_B PARENT_CATEGORY6_B, EGP_CATEGORIES_B PARENT_CATEGORY7_B, EGP_CATEGORIES_B PARENT_CATEGORY8_B, EGP_CATEGORIES_B PARENT_CATEGORY9_B, EGP_CATEGORIES_B PARENT_CATEGORY10_B, EGP_CATEGORIES_B PARENT_CATEGORY11_B, EGP_CATEGORIES_B PARENT_CATEGORY12_B, EGP_CATEGORIES_B PARENT_CATEGORY13_B, EGP_CATEGORIES_B PARENT_CATEGORY14_B, EGP_CATEGORIES_B PARENT_CATEGORY15_B, EGP_CATEGORIES_TL PARENT_CATEGORY1_TL, EGP_CATEGORIES_TL PARENT_CATEGORY2_TL, EGP_CATEGORIES_TL PARENT_CATEGORY3_TL, EGP_CATEGORIES_TL PARENT_CATEGORY4_TL, EGP_CATEGORIES_TL PARENT_CATEGORY5_TL, EGP_CATEGORIES_TL PARENT_CATEGORY6_TL, EGP_CATEGORIES_TL PARENT_CATEGORY7_TL, EGP_CATEGORIES_TL PARENT_CATEGORY8_TL, EGP_CATEGORIES_TL PARENT_CATEGORY9_TL, EGP_CATEGORIES_TL PARENT_CATEGORY10_TL, EGP_CATEGORIES_TL PARENT_CATEGORY11_TL, EGP_CATEGORIES_TL PARENT_CATEGORY12_TL, EGP_CATEGORIES_TL PARENT_CATEGORY13_TL, EGP_CATEGORIES_TL PARENT_CATEGORY14_TL, EGP_CATEGORIES_TL PARENT_CATEGORY15_TL WHERE FULL_CATEGORY_LIST.LOAD_ID = egp_refresh_mv_util.get_active_catalog_partition() AND FULL_CATEGORY_LIST.CATEGORY_SET_ID = CATALOG_B.CATEGORY_SET_ID(+) AND FULL_CATEGORY_LIST.CATEGORY_ID = CATEGORY_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID1 = PARENT_CATEGORY1_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID2 = PARENT_CATEGORY2_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID3 = PARENT_CATEGORY3_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID4 = PARENT_CATEGORY4_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID5 = PARENT_CATEGORY5_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID6 = PARENT_CATEGORY6_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID7 = PARENT_CATEGORY7_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID8 = PARENT_CATEGORY8_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID9 = PARENT_CATEGORY9_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID10 = PARENT_CATEGORY10_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID11 = PARENT_CATEGORY11_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID12 = PARENT_CATEGORY12_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID13 = PARENT_CATEGORY13_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID14 = PARENT_CATEGORY14_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID15 = PARENT_CATEGORY15_B.CATEGORY_ID(+) AND FULL_CATEGORY_LIST.CATEGORY_SET_ID = CATALOG_TL.CATEGORY_SET_ID(+) AND USERENV('LANG') = CATALOG_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.CATEGORY_ID = CATEGORY_TL.CATEGORY_ID(+) AND USERENV('LANG') = CATEGORY_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID1 = PARENT_CATEGORY1_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY1_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID2 = PARENT_CATEGORY2_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY2_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID3 = PARENT_CATEGORY3_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY3_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID4 = PARENT_CATEGORY4_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY4_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID5 = PARENT_CATEGORY5_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY5_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID6 = PARENT_CATEGORY6_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY6_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID7 = PARENT_CATEGORY7_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY7_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID8 = PARENT_CATEGORY8_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY8_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID9 = PARENT_CATEGORY9_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY9_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID10 = PARENT_CATEGORY10_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY10_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID11 = PARENT_CATEGORY11_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY11_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID12 = PARENT_CATEGORY12_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY12_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID13 = PARENT_CATEGORY13_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY13_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID14 = PARENT_CATEGORY14_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY14_TL.LANGUAGE(+) AND FULL_CATEGORY_LIST.PARENT_CATEGORY_ID15 = PARENT_CATEGORY15_TL.CATEGORY_ID(+) AND USERENV('LANG') = PARENT_CATEGORY15_TL.LANGUAGE(+) |