APPS.EGO_TA_BULKLOAD_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 2536: FROM mtl_item_catalog_groups_b cat

2532: ) RETURN BOOLEAN IS
2533:
2534: CURSOR c IS
2535: SELECT cat.parent_catalog_group_id
2536: FROM mtl_item_catalog_groups_b cat
2537: WHERE cat.item_catalog_group_id = p_item_catalog_group_id;
2538:
2539: l_ret mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;
2540:

Line 2539: l_ret mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;

2535: SELECT cat.parent_catalog_group_id
2536: FROM mtl_item_catalog_groups_b cat
2537: WHERE cat.item_catalog_group_id = p_item_catalog_group_id;
2538:
2539: l_ret mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;
2540:
2541: BEGIN
2542: OPEN c;
2543: FETCH c INTO l_ret;

Line 2604: FROM mtl_item_catalog_groups_b micg

2600: SELECT heir.item_catalog_group_id,
2601: heir.lev
2602: FROM (SELECT item_catalog_group_id ,
2603: level lev
2604: FROM mtl_item_catalog_groups_b micg
2605: START WITH item_catalog_group_id = p_item_catalog_group_id
2606: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
2607: ) heir
2608: WHERE heir.lev > 1 -- only parents

Line 3108: FROM mtl_item_catalog_groups_b START

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
3110: ) hier
3111: WHERE ag.attr_group_type = 'EGO_ITEM_TRANS_ATTR_GROUP'
3112: AND assocs.attr_group_id = ag.attr_group_id

Line 3174: FROM MTL_ITEM_CATALOG_GROUPS_B START

3170: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3171: EGO_ATTRS_V ATTRS ,
3172: (SELECT ITEM_CATALOG_GROUP_ID ,
3173: LEVEL LEV
3174: FROM MTL_ITEM_CATALOG_GROUPS_B START
3175: WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
3176: ) HIER
3177: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id
3178: AND attrs.attr_id = versions.attr_id

Line 3254: FROM MTL_ITEM_CATALOG_GROUPS_B

3250: Hier.lev
3251: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3252: (SELECT ITEM_CATALOG_GROUP_ID ,
3253: LEVEL LEV
3254: FROM MTL_ITEM_CATALOG_GROUPS_B
3255: START WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3256: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
3257: ) HIER
3258: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id