APPS.EGO_ITEM_CATALOG_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 833: ' FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||

829: 'FROM AK_CRITERIA cols , '||
830: ' EGO_CRITERIA_TEMPLATES_V criterions '||
831: 'WHERE cols.customization_code = criterions.customization_code '||
832: ' AND ( criterions.classification1 IN ( SELECT item_catalog_group_id '||
833: ' FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||
834: ' parent_catalog_group_id START WITH parent_catalog_group_id = :1 ) '||
835: ' OR criterions.classification1 = :2 ) '||
836: ' AND cols.attribute_code LIKE :3 '||
837: ' AND criterions.REGION_CODE LIKE ''EGO%'' '||

Line 858: ' FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||

854: 'FROM AK_CUSTOM_REGION_ITEMS COLS, ' ||
855: ' EGO_RESULTS_FORMAT_V RF ' ||
856: 'WHERE cols.customization_code = RF.customization_code ' ||
857: ' AND ( RF.classification1 IN ( SELECT item_catalog_group_id '||
858: ' FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||
859: ' parent_catalog_group_id START WITH parent_catalog_group_id = :1 ) '||
860: ' OR RF.classification1 = :2 ) '||
861: ' AND cols.attribute_code LIKE :3 '||
862: ' AND RF.REGION_CODE LIKE ''EGO%'' ' ||

Line 1001: from MTL_ITEM_CATALOG_GROUPS_B

997: ATTRIBUTE13,
998: ATTRIBUTE14,
999: ATTRIBUTE15,
1000: REQUEST_ID
1001: from MTL_ITEM_CATALOG_GROUPS_B
1002: where ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
1003: for update of ITEM_CATALOG_GROUP_ID nowait;
1004: recinfo c%rowtype;
1005: