APPS.EGO_ITEM_CATALOG_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

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

895: 'FROM AK_CRITERIA cols , '||
896: ' EGO_CRITERIA_TEMPLATES_V criterions '||
897: 'WHERE cols.customization_code = criterions.customization_code '||
898: ' AND ( criterions.classification1 IN ( SELECT item_catalog_group_id '||
899: ' FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||
900: ' parent_catalog_group_id START WITH parent_catalog_group_id = :1 ) '||
901: ' OR criterions.classification1 = :2 ) '||
902: ' AND cols.attribute_code LIKE :3 '||
903: ' AND criterions.REGION_CODE LIKE ''EGO%'' '||

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

920: 'FROM AK_CUSTOM_REGION_ITEMS COLS, ' ||
921: ' EGO_RESULTS_FORMAT_V RF ' ||
922: 'WHERE cols.customization_code = RF.customization_code ' ||
923: ' AND ( RF.classification1 IN ( SELECT item_catalog_group_id '||
924: ' FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||
925: ' parent_catalog_group_id START WITH parent_catalog_group_id = :1 ) '||
926: ' OR RF.classification1 = :2 ) '||
927: ' AND cols.attribute_code LIKE :3 '||
928: ' AND RF.REGION_CODE LIKE ''EGO%'' ' ||

Line 1067: from MTL_ITEM_CATALOG_GROUPS_B

1063: ATTRIBUTE13,
1064: ATTRIBUTE14,
1065: ATTRIBUTE15,
1066: REQUEST_ID
1067: from MTL_ITEM_CATALOG_GROUPS_B
1068: where ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
1069: for update of ITEM_CATALOG_GROUP_ID nowait;
1070: recinfo c%rowtype;
1071: