eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_PLAN_ORGANIZATIONS_V

Line 179: FROM msc_plan_organizations_v plan_org

175: LENGTH( apps.instance_code)+2
176: FROM msc_apps_instances apps,
177: ( SELECT distinct
178: sr_instance_id
179: FROM msc_plan_organizations_v plan_org
180: WHERE plan_org.plan_id = arg_plan_id
181: AND plan_org.organization_id = arg_org_id
182: AND plan_org.owning_sr_instance = arg_sr_instance
183: AND plan_org.sr_instance_id =

Line 756: from msc_plan_organizations_v

752: quantity_in_process = 0,
753: implement_ship_method = NULL
754: WHERE organization_id IN
755: (select planned_organization
756: from msc_plan_organizations_v
757: where organization_id = arg_owning_org_id
758: and owning_sr_instance = arg_owning_instance
759: and plan_id = arg_plan_id
760: AND planned_organization = decode(arg_log_org_id,

Line 878: msc_plan_organizations_v orgs,

874: lv_instance_id,
875: lv_org_id,
876: lv_plan_id
877: FROM msc_supplies s,
878: msc_plan_organizations_v orgs,
879: msc_system_items msi,
880: msc_plans mp
881: WHERE mp.plan_id = arg_plan_id
882: AND s.release_errors is NULL

Line 907: msc_plan_organizations_v orgs

903:
904: s.organization_id,
905: s.plan_id
906: FROM msc_supplies s,
907: msc_plan_organizations_v orgs
908: WHERE s.release_errors is NULL
909: AND nvl(s.cfm_routing_flag,0) = 3
910: AND s.implement_quantity > 0
911: AND s.organization_id = orgs.planned_organization

Line 1771: msc_plan_organizations_v orgs

1767: lv_org_id,
1768: lv_plan_id
1769: FROM msc_plans mp,
1770: msc_supplies s,
1771: msc_plan_organizations_v orgs
1772: WHERE mp.plan_id = arg_plan_id
1773: AND s.release_errors is NULL
1774: AND s.implement_quantity > 0
1775: AND s.organization_id = orgs.planned_organization

Line 1921: msc_plan_organizations_v orgs

1917: msc_parameters param,
1918: msc_item_id_lid item_lid,
1919:
1920: msc_supplies s,
1921: msc_plan_organizations_v orgs
1922: WHERE tp.sr_tp_id= s.organization_id
1923: AND tp.sr_instance_id= s.sr_instance_id
1924: AND tp.partner_type=3
1925: AND param.organization_id = s.organization_id

Line 2675: msc_plan_organizations_v orgs,

2671: lv_org_id,
2672: lv_plan_id,
2673: lv_round_primary_item
2674: FROM msc_supplies s,
2675: msc_plan_organizations_v orgs,
2676: msc_system_items msi, -- REMOVE
2677: msc_plans mp
2678: WHERE mp.plan_id = arg_plan_id
2679: AND s.release_errors is NULL

Line 2704: msc_plan_organizations_v orgs

2700: s.organization_id,
2701: s.plan_id,
2702: 2 /* setting rounding control to 2 ,since details are not released and this flag is used in details*/
2703: FROM msc_supplies s,
2704: msc_plan_organizations_v orgs
2705: WHERE s.release_errors is NULL
2706: AND s.implement_quantity > 0
2707: AND s.organization_id = orgs.planned_organization
2708: AND s.sr_instance_id = orgs.sr_instance_id

Line 3779: msc_plan_organizations_v orgs,

3775: lv_instance_id,
3776: lv_org_id,
3777: lv_plan_id
3778: FROM msc_supplies s,
3779: msc_plan_organizations_v orgs,
3780: msc_plans mp
3781: WHERE s.release_errors is NULL
3782: AND s.implement_quantity > 0
3783: AND s.organization_id = orgs.planned_organization

Line 3948: msc_plan_organizations_v orgs

3944: FROM msc_trading_partners tp,
3945: msc_parameters param,
3946: msc_supplies s,
3947: msc_item_id_lid item_lid,
3948: msc_plan_organizations_v orgs
3949: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
3950: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
3951: AND item_lid.inventory_item_id = s.inventory_item_id
3952: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct ? -- ey, should be s.sr_instance_id -- MN:done