APPS.EGO_TRANSACTION_ATTRS_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 574: FROM mtl_item_catalog_groups_b START

570: EGO_TRANS_ATTR_VERS_B versions ,
571: mtl_item_catalog_groups_kfv icv ,
572: (SELECT item_catalog_group_id ,
573: LEVEL lev
574: FROM mtl_item_catalog_groups_b START
575: WITH item_catalog_group_id = p_item_cat_group_id CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
576: ) hier
577: WHERE ag.attr_group_type = 'EGO_ITEM_TRANS_ATTR_GROUP'
578: AND assocs.attr_group_id = ag.attr_group_id

Line 640: FROM MTL_ITEM_CATALOG_GROUPS_B START

636: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
637: EGO_ATTRS_V ATTRS ,
638: (SELECT ITEM_CATALOG_GROUP_ID ,
639: LEVEL LEV
640: FROM MTL_ITEM_CATALOG_GROUPS_B START
641: WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
642: ) HIER
643: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id
644: AND attrs.attr_id = versions.attr_id

Line 720: FROM MTL_ITEM_CATALOG_GROUPS_B

716: Hier.lev
717: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
718: (SELECT ITEM_CATALOG_GROUP_ID ,
719: LEVEL LEV
720: FROM MTL_ITEM_CATALOG_GROUPS_B
721: START WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
722: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
723: ) HIER
724: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id

Line 907: FROM MTL_ITEM_CATALOG_GROUPS_B

903: Hier.lev
904: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
905: (SELECT ITEM_CATALOG_GROUP_ID ,
906: LEVEL LEV
907: FROM MTL_ITEM_CATALOG_GROUPS_B
908: START WITH ITEM_CATALOG_GROUP_ID = CP_ITEM_CAT_GROUP_ID
909: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
910: ) HIER
911: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id

Line 2184: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||

2180: ' HIERLEVEL.lev '||
2181: ' FROM EGO_TRANS_ATTR_VERS_B TA_VERS , '||
2182: ' ( SELECT ITEM_CATALOG_GROUP_ID , '||
2183: ' LEVEL LEV '||
2184: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
2185: ' START WITH ITEM_CATALOG_GROUP_ID =:1 '||
2186: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID '||
2187: ' ) HIERLEVEL '||
2188: ' WHERE HIERLEVEL.ITEM_CATALOG_GROUP_ID = TA_VERS.item_catalog_group_id '||

Line 2334: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||

2330: ' HIERLEVEL.lev '||
2331: ' FROM EGO_TRANS_ATTR_VERS_B TA_VERS , '||
2332: ' ( SELECT ITEM_CATALOG_GROUP_ID , '||
2333: ' LEVEL LEV '||
2334: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
2335: ' START WITH ITEM_CATALOG_GROUP_ID =:1 '||
2336: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID '||
2337: ' ) HIERLEVEL '||
2338: ' WHERE HIERLEVEL.ITEM_CATALOG_GROUP_ID = TA_VERS.item_catalog_group_id '||

Line 2557: FROM MTL_ITEM_CATALOG_GROUPS_B START WITH ITEM_CATALOG_GROUP_ID = v_ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID

2553: VERSIONS.CHECK_ELIGIBILITY ,
2554: Hier.lev
2555: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
2556: (SELECT ITEM_CATALOG_GROUP_ID , LEVEL LEV
2557: FROM MTL_ITEM_CATALOG_GROUPS_B START WITH ITEM_CATALOG_GROUP_ID = v_ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
2558: ) HIER
2559: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id AND versions.attr_id = v_attr_id )
2560: WHERE
2561: ( (LEV =1 AND ICC_VERSION_NUMBER = l_version_seq_id AND METADATA_LEVEL = 'ICC' )

Line 2631: FROM MTL_ITEM_CATALOG_GROUPS_B START WITH ITEM_CATALOG_GROUP_ID = v_ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID

2627: VERSIONS.CHECK_ELIGIBILITY ,
2628: Hier.lev
2629: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
2630: (SELECT ITEM_CATALOG_GROUP_ID , LEVEL LEV
2631: FROM MTL_ITEM_CATALOG_GROUPS_B START WITH ITEM_CATALOG_GROUP_ID = v_ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
2632: ) HIER
2633: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id AND versions.attr_id = v_attr_id )
2634: WHERE
2635: ( (LEV =1 AND ICC_VERSION_NUMBER = p_icc_version AND METADATA_LEVEL = 'ICC' )