DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_SYSTEM_ITEMS

Line 750: from msc_system_items

746:
747: cursor base_item is
748: select decode(bom_item_type, 4, NVL(base_item_id, inventory_item_id),
749: inventory_item_id )
750: from msc_system_items
751: where plan_id = p_plan_id
752: and inventory_item_id = v_item_id;
753:
754: cursor config_list (p_base_item NUMBER,

Line 757: from msc_system_items i,

753:
754: cursor config_list (p_base_item NUMBER,
755: l_supplier_id NUMBER)is
756: select distinct i.inventory_item_id
757: from msc_system_items i,
758: msc_item_suppliers s
759: where i.base_item_id = p_base_item
760: and i.plan_id = p_plan_id
761: and i.bom_item_type = 4