DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 574: from bom_components_b bcb, mtl_system_items_b msib

570:
571:
572: cursor comp_rows(bill_id IN NUMBER) is
573: select msib.bom_item_type, msib.replenish_to_order_flag, bcb.optional
574: from bom_components_b bcb, mtl_system_items_b msib
575: where bcb.bill_sequence_id = bill_id
576: and msib.inventory_item_id = bcb.component_item_id
577: and msib.organization_id = bcb.pk2_value;
578:

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

586:
587: BEGIN
588:
589: select msib.bom_item_type, msib.pick_components_flag into l_parent_BIT, l_PTO_flag
590: from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;
591:
592: for bill in all_bills(X_org_id, X_eng_item_id,
593: X_designator_option, X_alt_bom_designator) loop
594: