APPS.MSC_ATP_REQ dependencies on MSC_INTERORG_SHIP_METHODS

Line 12613: msc_interorg_ship_methods s,

12609: SELECT c.calendar_date l_date,
12610: s.weight_capacity weight,
12611: s.volume_capacity volume
12612: FROM msc_calendar_dates c,
12613: msc_interorg_ship_methods s,
12614: msc_trading_partners tp,
12615: msc_plans p
12616: WHERE s.plan_id = p_plan_id
12617: AND s.from_organization_id = p_from_organization_id

Line 13011: msc_interorg_ship_methods s,

13007: null col28, -- pegging_id
13008: null col29 -- end_pegging_id
13009: FROM
13010: msc_calendar_dates c,
13011: msc_interorg_ship_methods s,
13012: msc_trading_partners tp,
13013: msc_plans p
13014: WHERE
13015: s.plan_id = p_plan_id

Line 13058: msc_interorg_ship_methods s

13054: p_scenario_id col27, -- scenairo_id
13055: null col28, -- pegging_id
13056: null col29 -- end_pegging_id
13057: FROM msc_supplies sup,
13058: msc_interorg_ship_methods s
13059: WHERE sup.plan_id = p_plan_id
13060: AND sup.organization_id = p_to_organization_id
13061: AND sup.sr_instance_id = p_dest_org_instance_id
13062: AND sup.source_organization_id is not null

Line 13171: msc_interorg_ship_methods s,

13167: null col28, -- pegging_id
13168: null col29 -- end_pegging_id
13169: FROM
13170: msc_calendar_dates c,
13171: msc_interorg_ship_methods s,
13172: msc_trading_partners tp,
13173: msc_plans p
13174: WHERE
13175: s.plan_id = p_plan_id

Line 13218: msc_interorg_ship_methods s

13214: p_scenario_id col27, -- scenairo_id
13215: null col28, -- pegging_id
13216: null col29 -- end_pegging_id
13217: FROM msc_supplies sup,
13218: msc_interorg_ship_methods s
13219: WHERE sup.plan_id = p_plan_id
13220: AND sup.organization_id = p_to_organization_id
13221: AND sup.sr_instance_id = p_dest_org_instance_id
13222: AND sup.source_organization_id is not null