APPS.MSC_GANTT_PKG dependencies on MSC_SUPPLIER_REQUIREMENTS

Line 1987: msc_supplier_requirements msr

1983: elsif ( p_from_view_type = SUPPLIER_VIEW ) then
1984: select distinct msr.sr_instance_id, msr.organization_id, msr.supply_id
1985: bulk collect into v_inst_id, v_org_id, v_trx_id
1986: from msc_gantt_query mgq,
1987: msc_supplier_requirements msr
1988: where mgq.query_id = p_from_query_id
1989: and mgq.row_index = p_from_index
1990: and msr.plan_id = g_plan_id
1991: --and msr.sr_instance_id = mgq.sr_instance_id

Line 2814: from msc_supplier_requirements msr

2810: --5516790 bugfix
2811: function getNewViewStartDate(p_node_type number, p_trx_id number, p_to_view_type number) return date is
2812: cursor c_supp_view_date1 is
2813: select min(msr.consumption_date) start_date
2814: from msc_supplier_requirements msr
2815: where msr.plan_id = g_plan_id
2816: and msr.supply_id = p_trx_id;
2817:
2818: cursor c_supp_view_date2 is

Line 2820: from msc_supplier_requirements msr,

2816: and msr.supply_id = p_trx_id;
2817:
2818: cursor c_supp_view_date2 is
2819: select min(msr.consumption_date) start_date
2820: from msc_supplier_requirements msr,
2821: msc_resource_requirements mrr
2822: where mrr.plan_id = g_plan_id
2823: and mrr.transaction_id = p_trx_id
2824: and msr.plan_id = mrr.plan_id