APPS.MSC_DRP_UTIL dependencies on MSC_ITEM_SOURCING

Line 406: from msc_item_sourcing mis,

402: p_to_org_id number, p_to_org_inst_id number,
403: p_rank number) return varchar2 IS
404: cursor name_c is
405: select msr.sourcing_rule_name
406: from msc_item_sourcing mis,
407: msc_sourcing_rules msr
408: where mis.plan_id = p_plan_id
409: and mis.inventory_item_id = p_item_id
410: and mis.source_organization_id = p_from_org_id

Line 971: from msc_item_sourcing mis

967: select source_organization_id,
968: sr_instance_id2,
969: min(avg_transit_lead_time),
970: max(avg_transit_lead_time)
971: from msc_item_sourcing mis
972: where mis.plan_id = p_plan_id
973: and mis.inventory_item_id = p_item_id
974: and mis.organization_id = p_org_id
975: and mis.sr_instance_id = p_inst_id