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 180: FROM msc_plan_organizations_v plan_org

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

Line 775: from msc_plan_organizations_v

771: quantity_in_process = 0,
772: implement_ship_method = NULL
773: WHERE organization_id IN
774: (select planned_organization
775: from msc_plan_organizations_v
776: where organization_id = arg_owning_org_id
777: and owning_sr_instance = arg_owning_instance
778: and plan_id = arg_plan_id
779: AND planned_organization = decode(arg_log_org_id,

Line 904: msc_plan_organizations_v orgs,

900: lv_instance_id,
901: lv_org_id,
902: lv_plan_id
903: FROM msc_supplies s,
904: msc_plan_organizations_v orgs,
905: msc_system_items msi,
906: msc_plans mp
907: WHERE mp.plan_id = arg_plan_id
908: AND s.release_errors is NULL

Line 933: msc_plan_organizations_v orgs

929:
930: s.organization_id,
931: s.plan_id
932: FROM msc_supplies s,
933: msc_plan_organizations_v orgs
934: WHERE s.release_errors is NULL
935: AND nvl(s.cfm_routing_flag,0) = 3
936: AND s.implement_quantity > 0
937: AND s.organization_id = orgs.planned_organization

Line 1798: msc_plan_organizations_v orgs

1794: lv_org_id,
1795: lv_plan_id
1796: FROM msc_plans mp,
1797: msc_supplies s,
1798: msc_plan_organizations_v orgs
1799: WHERE mp.plan_id = arg_plan_id
1800: AND s.release_errors is NULL
1801: AND s.implement_quantity > 0
1802: AND s.organization_id = orgs.planned_organization

Line 1948: msc_plan_organizations_v orgs

1944: msc_parameters param,
1945: msc_item_id_lid item_lid,
1946:
1947: msc_supplies s,
1948: msc_plan_organizations_v orgs
1949: WHERE tp.sr_tp_id= s.organization_id
1950: AND tp.sr_instance_id= s.sr_instance_id
1951: AND tp.partner_type=3
1952: AND param.organization_id = s.organization_id

Line 2702: msc_plan_organizations_v orgs,

2698: lv_org_id,
2699: lv_plan_id,
2700: lv_round_primary_item
2701: FROM msc_supplies s,
2702: msc_plan_organizations_v orgs,
2703: msc_system_items msi, -- REMOVE
2704: msc_plans mp
2705: WHERE mp.plan_id = arg_plan_id
2706: AND s.release_errors is NULL

Line 2731: msc_plan_organizations_v orgs

2727: s.organization_id,
2728: s.plan_id,
2729: 2 /* setting rounding control to 2 ,since details are not released and this flag is used in details*/
2730: FROM msc_supplies s,
2731: msc_plan_organizations_v orgs
2732: WHERE s.release_errors is NULL
2733: AND s.implement_quantity > 0
2734: AND s.organization_id = orgs.planned_organization
2735: AND s.sr_instance_id = orgs.sr_instance_id

Line 3806: msc_plan_organizations_v orgs,

3802: lv_instance_id,
3803: lv_org_id,
3804: lv_plan_id
3805: FROM msc_supplies s,
3806: msc_plan_organizations_v orgs,
3807: msc_plans mp
3808: WHERE s.release_errors is NULL
3809: AND s.implement_quantity > 0
3810: AND s.organization_id = orgs.planned_organization

Line 3976: msc_plan_organizations_v orgs,

3972: FROM msc_trading_partners tp,
3973: msc_parameters param,
3974: msc_supplies s,
3975: msc_item_id_lid item_lid,
3976: msc_plan_organizations_v orgs,
3977: msc_demands md
3978: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
3979: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
3980: AND item_lid.inventory_item_id = s.inventory_item_id

Line 4116: msc_plan_organizations_v orgs

4112: FROM msc_trading_partners tp,
4113: msc_parameters param,
4114: msc_supplies s,
4115: msc_item_id_lid item_lid,
4116: msc_plan_organizations_v orgs
4117: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4118: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
4119: AND item_lid.inventory_item_id = s.inventory_item_id
4120: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct ? -- ey, should be s.sr_instance_id -- MN:done

Line 4253: msc_plan_organizations_v orgs

4249: FROM msc_trading_partners tp,
4250: msc_parameters param,
4251: msc_supplies s,
4252: msc_item_id_lid item_lid,
4253: msc_plan_organizations_v orgs
4254: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4255: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
4256: AND item_lid.inventory_item_id = s.inventory_item_id
4257: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct ? -- ey, should be s.sr_instance_id -- MN:done