APPS.MSC_GANTT_UTILS dependencies on MSC_ITEM_SUPPLIERS

Line 3912: from msc_item_suppliers

3908: where query_id = p_query_id;
3909:
3910: cursor c_mis_inst_org (l_plan number, l_item number, l_supp number, l_supp_site number) is
3911: select sr_instance_id, organization_id
3912: from msc_item_suppliers
3913: where plan_id = l_plan
3914: and inventory_item_id = l_item
3915: and supplier_id = l_supp
3916: and supplier_site_id = l_supp_site;

Line 3945: msc_item_suppliers mis,

3941: bulk collect into v_row_index, v_start_date, v_qty
3942: from msc_calendar_dates mca,
3943: msc_plans mp,
3944: msc_supplier_capacities msc,
3945: msc_item_suppliers mis,
3946: msc_gantt_query mgq
3947: where mgq.query_id = p_query_id
3948: and mgq.row_index = l_row_index
3949: and mgq.row_flag = SYS_YES

Line 3988: msc_item_suppliers mis,

3984: bulk collect into v_row_index, v_start_date, v_qty
3985: from msc_form_query mfq,
3986: msc_plans mp,
3987: msc_supplier_capacities msc,
3988: msc_item_suppliers mis,
3989: msc_gantt_query mgq
3990: where mgq.query_id = p_query_id
3991: and mgq.row_index = l_row_index
3992: and mgq.row_flag = SYS_YES

Line 9037: msc_item_suppliers mis,

9033: FROM msc_trading_partners mtp,
9034: --msc_trading_partners mtp2,
9035: msc_trading_partner_sites mtps,
9036: msc_system_items msi,
9037: msc_item_suppliers mis,
9038: msc_gantt_query mgq
9039: WHERE mgq.query_id = :p_query_id
9040: and mis.plan_id = mgq.plan_id
9041: and mis.supplier_id = mgq.supplier_id