DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_ITEM_SOURCING

Line 410: from msc_item_sourcing mis,

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

Line 980: from msc_item_sourcing mis

976: select source_organization_id,
977: sr_instance_id2,
978: min(avg_transit_lead_time),
979: max(avg_transit_lead_time)
980: from msc_item_sourcing mis
981: where mis.plan_id = p_plan_id
982: and mis.inventory_item_id = p_item_id
983: and mis.organization_id = p_org_id
984: and mis.sr_instance_id = p_inst_id