DBA Data[Home] [Help]

APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_ITEM_SOURCING

Line 2639: from msc_item_sourcing

2635: and msi.inventory_item_id = v_item_id;
2636:
2637: cursor from_to_org_c IS
2638: select source_organization_id, sr_instance_id2
2639: from msc_item_sourcing
2640: where plan_id = p_plan_id
2641: and organization_id = v_org_id
2642: and inventory_item_id = v_item_id
2643: and sr_instance_id = v_inst_id

Line 2648: from msc_item_sourcing

2644: and (source_organization_id <> organization_id or
2645: sr_instance_id2 <> sr_instance_id)
2646: and source_organization_id <> -1
2647: union select organization_id, sr_instance_id
2648: from msc_item_sourcing
2649: where plan_id = p_plan_id
2650: and source_organization_id = v_org_id
2651: and inventory_item_id = v_item_id
2652: and sr_instance_id2 = v_inst_id