APPS.ONT_ASSGN_ITEM_FROM_PRH_TO_PRC dependencies on MTL_ITEM_CATEGORIES

Line 97: from mtl_item_categories ic,

93: ic.organization_id,
94: prh.segment8,
95: prh.category_id,
96: prh.description
97: from mtl_item_categories ic,
98: mtl_categories_b prc,
99: mtl_categories_b prh
100: where prc.category_id = ic.category_id
101: and prc.structure_id = prc_structure_id

Line 108: from mtl_item_categories ic2, mtl_categories_b c2

104: and prh.segment8 = prc.segment1
105: and prh.structure_id = prh_structure_id
106: and not EXISTS
107: (select 'x'
108: from mtl_item_categories ic2, mtl_categories_b c2
109: where c2.category_id = ic2.category_id
110: and c2.structure_id = prh_structure_id
111: and ic2.category_set_id = prh_category_set_id
112: and ic2.inventory_item_id = ic.inventory_item_id

Line 122: from mtl_item_categories ic,

118: -- Only those items which are existing in this cursor
119: ------------------------------------------------------
120: CURSOR c_get_valid_item(p_org_id number, p_inventory_item_id number) IS
121: select 'x'
122: from mtl_item_categories ic,
123: mtl_system_items_b msi,
124: mtl_categories_b c
125: where msi.organization_id = p_org_id
126: and msi.inventory_item_id = p_inventory_item_id

Line 174: * mtl_item_categories.

170: end;
171:
172: /**
173: * Remove all the associations for disabled categories from
174: * mtl_item_categories.
175: **/
176:
177: delete from mtl_item_categories
178: where category_id in

Line 177: delete from mtl_item_categories

173: * Remove all the associations for disabled categories from
174: * mtl_item_categories.
175: **/
176:
177: delete from mtl_item_categories
178: where category_id in
179: (
180: select c.category_id
181: from mtl_categories_b c