APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on IBE_CT_RELATION_RULES

Line 272: FROM ibe_ct_relation_rules

268: ' AND ms.auto_created_config_flag = ' || '''' || 'Y' || '''' || ') ';
269:
270: CURSOR c_categories(c_section_id NUMBER) IS
271: SELECT dest_object_id
272: FROM ibe_ct_relation_rules
273: WHERE relation_type_code = 'AUTOPLACEMENT'
274: AND origin_object_type = 'S'
275: AND dest_object_type = 'C'
276: AND origin_object_id = c_section_id;

Line 618: l_sql VARCHAR2(2000) := 'SELECT 1 FROM mtl_item_categories mic, ibe_ct_relation_rules rule, mtl_system_items_vl ms ' ||

614: --04/20/09 amaheshw Bug 8415339
615: TYPE ItemCurType IS REF CURSOR;
616: c_check_item ItemCurType;
617:
618: l_sql VARCHAR2(2000) := 'SELECT 1 FROM mtl_item_categories mic, ibe_ct_relation_rules rule, mtl_system_items_vl ms ' ||
619: ' WHERE mic.category_set_id = :c_category_set_id ' ||
620: ' AND mic.organization_id = :p_organization_id ' ||
621: ' AND mic.inventory_item_id = :c_inventory_item_id ' ||
622: ' AND mic.category_id = rule.dest_object_id ' ||

Line 639: SELECT 1 FROM mtl_item_categories mic, ibe_ct_relation_rules rule,

635: /* Commented 04/20/09 amaheshw Bug 8415339
636: CURSOR c_check_item(c_section_id NUMBER,
637: c_category_set_id NUMBER, c_organization_id NUMBER,
638: c_inventory_item_id NUMBER) IS
639: SELECT 1 FROM mtl_item_categories mic, ibe_ct_relation_rules rule,
640: mtl_system_items_vl ms
641: WHERE mic.category_set_id = c_category_set_id
642: AND mic.organization_id = p_organization_id
643: AND mic.inventory_item_id = c_inventory_item_id