APPS.EGO_TA_BULKLOAD_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 1682: FROM mtl_item_catalog_groups_kfv icc_kfv

1678: /* NOt Req now are we are doing this in Bulk_Validate_Trans_Attrs_ICC */
1679: /*
1680: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1681: SET item_catalog_group_id = (SELECt icc_kfv.item_catalog_group_id
1682: FROM mtl_item_catalog_groups_kfv icc_kfv
1683: where Upper(icc_kfv.concatenated_segments) = Upper(ETAVT.item_catalog_group_name)
1684: )
1685: WHERE ETAVT.item_catalog_group_name IS NOT NULL
1686: AND ETAVT.item_catalog_group_id IS NULL

Line 2032: FROM mtl_item_catalog_groups_kfv icc_kfv

2028: AND p_ta_intf_tbl(i).item_catalog_group_name IS NOT NULL) THEN
2029:
2030: BEGIN
2031: SELECt icc_kfv.item_catalog_group_id INTO p_ta_intf_tbl(i).item_catalog_group_id
2032: FROM mtl_item_catalog_groups_kfv icc_kfv
2033: WHERE Upper(icc_kfv.concatenated_segments) = Upper(p_ta_intf_tbl(i).item_catalog_group_name);
2034: EXCEPTION
2035: WHEN no_data_found THEN
2036: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'ICC '

Line 3105: mtl_item_catalog_groups_kfv icv ,

3101: FROM ego_obj_AG_assocs_b assocs ,
3102: ego_attrs_v attrs ,
3103: ego_attr_groups_v ag ,
3104: EGO_TRANS_ATTR_VERS_B versions ,
3105: mtl_item_catalog_groups_kfv icv ,
3106: (SELECT item_catalog_group_id ,
3107: LEVEL lev
3108: FROM mtl_item_catalog_groups_b START
3109: WITH item_catalog_group_id = p_item_cat_group_id CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id