83:
84:
85: cursor comp_rows(bill_id IN NUMBER) is
86: select msib.bom_item_type, msib.replenish_to_order_flag, bcb.optional
87: from bom_components_b bcb, mtl_system_items_b msib
88: where bcb.bill_sequence_id = bill_id
89: and msib.inventory_item_id = bcb.component_item_id
90: and msib.organization_id = bcb.pk2_value;
91:
302:
303:
304: cursor comp_rows(bill_id IN NUMBER) is
305: select msib.bom_item_type, msib.replenish_to_order_flag, bcb.optional
306: from bom_components_b bcb, mtl_system_items_b msib
307: where bcb.bill_sequence_id = bill_id
308: and msib.inventory_item_id = bcb.component_item_id
309: and msib.organization_id = bcb.pk2_value;
310: