APPS.MSC_PHUB_UTIL dependencies on MSC_PLAN_RUNS

Line 915: from msc_resource_requirements mrr, msc_plan_runs mpr

911: mrr.sr_instance_id,
912: mrr.organization_id,
913: mrr.department_id,
914: mrr.resource_id
915: from msc_resource_requirements mrr, msc_plan_runs mpr
916: where mpr.plan_id = p_plan_id
917: and mpr.plan_run_id = p_plan_run_id
918: and mrr.plan_id = p_plan_id
919: and mrr.sr_instance_id = mpr.sr_instance_id

Line 930: from msc_net_resource_avail mra, msc_plan_runs mpr

926: mra.sr_instance_id,
927: mra.organization_id,
928: mra.department_id,
929: mra.resource_id
930: from msc_net_resource_avail mra, msc_plan_runs mpr
931: where mpr.plan_id = p_plan_id
932: and mpr.plan_run_id = p_plan_run_id
933: and mra.plan_id = p_plan_id
934: and mra.sr_instance_id = mpr.sr_instance_id

Line 967: from msc_supplies ms, msc_plan_runs mpr

963: ms.plan_id,
964: ms.sr_instance_id,
965: ms.organization_id,
966: ms.inventory_item_id
967: from msc_supplies ms, msc_plan_runs mpr
968: where mpr.plan_id = p_plan_id
969: and mpr.plan_run_id = p_plan_run_id
970: and ms.plan_id = p_plan_id
971: and ms.sr_instance_id = mpr.sr_instance_id

Line 981: from msc_demands md, msc_plan_runs mpr

977: md.plan_id,
978: md.sr_instance_id,
979: md.organization_id,
980: md.inventory_item_id
981: from msc_demands md, msc_plan_runs mpr
982: where mpr.plan_id = p_plan_id
983: and mpr.plan_run_id = p_plan_run_id
984: and md.plan_id = p_plan_id
985: and md.sr_instance_id = mpr.sr_instance_id

Line 1000: from msc_trading_partners o, msc_plan_runs r

996: l_owning_currency_code varchar2(20);
997: begin
998: select nvl(o.currency_code, 'XXX')
999: into l_owning_currency_code
1000: from msc_trading_partners o, msc_plan_runs r
1001: where o.sr_instance_id(+)=r.sr_instance_id
1002: and o.sr_tp_id(+)=r.organization_id
1003: and o.partner_type(+)=3
1004: and r.plan_run_id=p_plan_run_id;