DBA Data[Home] [Help]

APPS.ENG_BOM_PKG dependencies on BOM_COMPONENTS_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 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: