APPS.ONT_ASSGN_ITEM_FROM_PRH_TO_PRC dependencies on MTL_CATEGORIES_B

Line 98: mtl_categories_b prc,

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
102: and ic.category_set_id = prc_category_set_id

Line 99: mtl_categories_b prh

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
102: and ic.category_set_id = prc_category_set_id
103: and prh.enabled_flag = 'Y'

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 124: mtl_categories_b c

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
127: and msi.inventory_item_id = ic.inventory_item_id
128: and msi.organization_id = ic.organization_id

Line 181: from mtl_categories_b c

177: delete from mtl_item_categories
178: where category_id in
179: (
180: select c.category_id
181: from mtl_categories_b c
182: where c.structure_id = prh_structure_id
183: and c.enabled_flag = 'N'
184: );
185: