APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 356: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||

352: ' ,ROW_NUMBER,ATTRIBUTE_STRING_VALUE,ATTRIBUTE_NUMBER_VALUE,ATTRIBUTE_DATE_VALUE,ATTRIBUTE_TRANSLATED_VALUE,ATTRIBUTE_UOM_CODE '||
353: ' ,REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,DATA_LEVEL_ID '||
354: ' FROM EGO_TEMPL_ATTRIBUTES TEMPL, '||
355: ' (SELECT CONNECT_BY_ROOT ITEM_CATALOG_GROUP_ID ROOT_CLASS, ITEM_CATALOG_GROUP_ID, PARENT_CATALOG_GROUP_ID, LEVEL CATALOG_LEVEL '||
356: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
357: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID= ITEM_CATALOG_GROUP_ID '||
358: ' START WITH ITEM_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID '||
359: ' ) CATALOG '||
360: ' WHERE TEMPL.CLASSIFICATION_CODE= CATALOG.ITEM_CATALOG_GROUP_ID '||

Line 366: l_class_code_hierarchy_sql := ' SELECT item_catalog_group_id FROM MTL_ITEM_CATALOG_GROUPS_B TEMPL CONNECT BY PRIOR TEMPL.PARENT_CATALOG_GROUP_ID = TEMPL.ITEM_CATALOG_GROUP_ID START WITH TEMPL.ITEM_CATALOG_GROUP_ID = ENTITIES.ITEM_CATALOG_GROUP_ID ';

362: ' ) '||
363: ' WHERE MIN_LEVEL = CATALOG_LEVEL ';
364:
365:
366: l_class_code_hierarchy_sql := ' SELECT item_catalog_group_id FROM MTL_ITEM_CATALOG_GROUPS_B TEMPL CONNECT BY PRIOR TEMPL.PARENT_CATALOG_GROUP_ID = TEMPL.ITEM_CATALOG_GROUP_ID START WITH TEMPL.ITEM_CATALOG_GROUP_ID = ENTITIES.ITEM_CATALOG_GROUP_ID ';
367: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEMMGMT_GROUP');
368: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
369: p_api_version => 1.0
370: ,p_application_id => 431

Line 4209: FROM mtl_item_catalog_groups_b

4205: ||Lpad(LEVEL,6,'0')
4206: ||'$$'
4207: ELSE NULL
4208: END) item_num_action_id
4209: FROM mtl_item_catalog_groups_b
4210: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id START WITH item_catalog_group_id = j.item_catalog_group_id);
4211:
4212: Debug_conc_log('INSERT_FUN_GEN_SETUP_UDAS: l_num_action_id: '
4213: ||l_num_action_id