DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_SYSTEM_ITEMS

Line 761: from msc_system_items

757:
758: cursor base_item is
759: select decode(bom_item_type, 4, NVL(base_item_id, inventory_item_id),
760: inventory_item_id )
761: from msc_system_items
762: where plan_id = p_plan_id
763: and inventory_item_id = v_item_id;
764:
765: cursor config_list (p_base_item NUMBER,

Line 768: from msc_system_items i,

764:
765: cursor config_list (p_base_item NUMBER,
766: l_supplier_id NUMBER)is
767: select distinct i.inventory_item_id
768: from msc_system_items i,
769: msc_item_suppliers s
770: where i.base_item_id = p_base_item
771: and i.plan_id = p_plan_id
772: and i.bom_item_type = 4