DBA Data[Home] [Help]

APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_ITEM_SOURCING

Line 2819: from msc_item_sourcing

2815: and msi.inventory_item_id = v_item_id;
2816:
2817: cursor from_to_org_c IS
2818: select source_organization_id, sr_instance_id2
2819: from msc_item_sourcing
2820: where plan_id = p_plan_id
2821: and organization_id = v_org_id
2822: and inventory_item_id = v_item_id
2823: and sr_instance_id = v_inst_id

Line 2828: from msc_item_sourcing

2824: and (source_organization_id <> organization_id or
2825: sr_instance_id2 <> sr_instance_id)
2826: and source_organization_id <> -1
2827: union select organization_id, sr_instance_id
2828: from msc_item_sourcing
2829: where plan_id = p_plan_id
2830: and source_organization_id = v_org_id
2831: and inventory_item_id = v_item_id
2832: and sr_instance_id2 = v_inst_id