37: and bbom.bill_sequence_id = bic.bill_sequence_id))
38: and (i_category_id is null or
39: msik.inventory_item_id in (
40: select mic.inventory_item_id
41: from mtl_item_categories mic
42: where mic.organization_id = i_org_id
43: and mic.category_set_id = i_category_set_id
44: and mic.category_id = i_category_id))
45: and (i_planner_code is null or
106: and bbom.bill_sequence_id = bic.bill_sequence_id))
107: and (i_category_id is null or
108: msik.inventory_item_id in
109: (select mic.inventory_item_id
110: from mtl_item_categories mic
111: where mic.organization_id = i_org_id
112: and mic.category_set_id = i_category_set_id
113: and mic.category_id = i_category_id))
114: and (i_planner_code is null or msik.planner_code = i_planner_code)
153: and bbom.bill_sequence_id = bic.bill_sequence_id))
154: and (i_category_id is null or
155: msik.inventory_item_id in (
156: select mic.inventory_item_id
157: from mtl_item_categories mic
158: where mic.organization_id = i_org_id
159: and mic.category_set_id = i_category_set_id
160: and mic.category_id = i_category_id))
161: and (i_planner_code is null or
322: and bbom.bill_sequence_id = bic.bill_sequence_id))
323: and (i_category_id is null or
324: msik.inventory_item_id in (
325: select mic.inventory_item_id
326: from mtl_item_categories mic
327: where mic.organization_id = i_org_id
328: and mic.category_set_id = i_category_set_id
329: and mic.category_id = i_category_id))
330: and (i_planner_code is null or