EGP_FULL_CATEGORY_LIST_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name

CATEGORY_SET_ID CATEGORY_ID PARENT_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 REFERENCE_CATEGORY_SET_ID CATEGORY_SHARED_FLAG LOAD_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME

Query

SQL_Statement

SELECT FULL_CATEGORY_LIST.category_set_id, FULL_CATEGORY_LIST.category_id, FULL_CATEGORY_LIST.parent_category_id, FULL_CATEGORY_LIST.parent_category_id1, FULL_CATEGORY_LIST.parent_category_id2, FULL_CATEGORY_LIST.parent_category_id3, FULL_CATEGORY_LIST.parent_category_id4, FULL_CATEGORY_LIST.parent_category_id5, FULL_CATEGORY_LIST.parent_category_id6, FULL_CATEGORY_LIST.parent_category_id7, FULL_CATEGORY_LIST.parent_category_id8, FULL_CATEGORY_LIST.parent_category_id9, FULL_CATEGORY_LIST.parent_category_id10, FULL_CATEGORY_LIST.parent_category_id11, FULL_CATEGORY_LIST.parent_category_id12, FULL_CATEGORY_LIST.parent_category_id13, FULL_CATEGORY_LIST.parent_category_id14, FULL_CATEGORY_LIST.parent_category_id15, FULL_CATEGORY_LIST.reference_category_set_id, FULL_CATEGORY_LIST.category_shared_flag, FULL_CATEGORY_LIST.load_id, FULL_CATEGORY_LIST.last_update_date, FULL_CATEGORY_LIST.last_updated_by, FULL_CATEGORY_LIST.creation_date, FULL_CATEGORY_LIST.created_by, FULL_CATEGORY_LIST.last_update_login, FULL_CATEGORY_LIST.request_id, FULL_CATEGORY_LIST.job_definition_name, FULL_CATEGORY_LIST.job_definition_package, FULL_CATEGORY_LIST.program_name, FULL_CATEGORY_LIST.program_app_name FROM egp_full_category_list FULL_CATEGORY_LIST WHERE FULL_CATEGORY_LIST.LOAD_ID = egp_refresh_mv_util.get_active_catalog_partition()