APPS.ENG_BOM_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 87: from bom_components_b bcb, mtl_system_items_b msib

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:

Line 98: select msib.bom_item_type, msib.pick_components_flag into l_parent_BIT, l_PTO_flag from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;

94:
95: --BOM ER 9946990 begin
96: X_stmt_num := 350;
97:
98: select msib.bom_item_type, msib.pick_components_flag into l_parent_BIT, l_PTO_flag from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;
99:
100: for bill in all_bills(X_org_id, X_eng_item_id, X_designator_option, X_alt_bom_designator)
101: loop
102:

Line 306: from bom_components_b bcb, mtl_system_items_b msib

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:

Line 345: from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;

341:
342: BEGIN
343:
344: select msib.bom_item_type, msib.pick_components_flag into l_parent_BIT, l_PTO_flag
345: from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;
346:
347: for bill in all_bills(X_org_id, X_eng_item_id,
348: X_designator_option, X_alt_bom_designator) loop
349: