EGP_FLATTENED_VALID_CATS

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

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(+)

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(+)