APPS.MSC_ATP_REQ dependencies on MSC_INTERORG_SHIP_METHODS

Line 12646: msc_interorg_ship_methods s,

12642: SELECT c.calendar_date l_date,
12643: s.weight_capacity weight,
12644: s.volume_capacity volume
12645: FROM msc_calendar_dates c,
12646: msc_interorg_ship_methods s,
12647: msc_trading_partners tp,
12648: msc_plans p
12649: WHERE s.plan_id = p_plan_id
12650: AND s.from_organization_id = p_from_organization_id

Line 13044: msc_interorg_ship_methods s,

13040: null col28, -- pegging_id
13041: null col29 -- end_pegging_id
13042: FROM
13043: msc_calendar_dates c,
13044: msc_interorg_ship_methods s,
13045: msc_trading_partners tp,
13046: msc_plans p
13047: WHERE
13048: s.plan_id = p_plan_id

Line 13091: msc_interorg_ship_methods s

13087: p_scenario_id col27, -- scenairo_id
13088: null col28, -- pegging_id
13089: null col29 -- end_pegging_id
13090: FROM msc_supplies sup,
13091: msc_interorg_ship_methods s
13092: WHERE sup.plan_id = p_plan_id
13093: AND sup.organization_id = p_to_organization_id
13094: AND sup.sr_instance_id = p_dest_org_instance_id
13095: AND sup.source_organization_id is not null

Line 13204: msc_interorg_ship_methods s,

13200: null col28, -- pegging_id
13201: null col29 -- end_pegging_id
13202: FROM
13203: msc_calendar_dates c,
13204: msc_interorg_ship_methods s,
13205: msc_trading_partners tp,
13206: msc_plans p
13207: WHERE
13208: s.plan_id = p_plan_id

Line 13251: msc_interorg_ship_methods s

13247: p_scenario_id col27, -- scenairo_id
13248: null col28, -- pegging_id
13249: null col29 -- end_pegging_id
13250: FROM msc_supplies sup,
13251: msc_interorg_ship_methods s
13252: WHERE sup.plan_id = p_plan_id
13253: AND sup.organization_id = p_to_organization_id
13254: AND sup.sr_instance_id = p_dest_org_instance_id
13255: AND sup.source_organization_id is not null