APPS.MSC_ATP_PROC dependencies on MSC_INTERORG_SHIP_METHODS

Line 3261: FROM msc_interorg_ship_methods msim

3257: p_instance_id NUMBER) IS
3258: SELECT msim.intransit_time,
3259: msim.ship_method,
3260: msim.default_flag
3261: FROM msc_interorg_ship_methods msim
3262: WHERE msim.plan_id = -1
3263: AND msim.from_location_id = p_from_location_id
3264: AND msim.sr_instance_id = p_source_instance_id
3265: AND msim.to_location_id = p_to_location_id

Line 3279: FROM msc_interorg_ship_methods mism,

3275: p_session_id NUMBER,
3276: p_partner_site_id NUMBER) IS
3277: SELECT ( (10 * (10 - mrt.region_type)) +
3278: DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level, mrt.region_id
3279: FROM msc_interorg_ship_methods mism,
3280: msc_regions_temp mrt
3281: WHERE mism.plan_id = -1
3282: AND mism.from_location_id = p_from_location_id
3283: AND mism.sr_instance_id = p_from_instance_id

Line 3750: ' FROM msc_interorg_ship_methods msim '||

3746: ',:created_by' ||
3747: ',sysdate' ||
3748: ',:last_update_by' ||
3749: ',:last_update_login ' ||
3750: ' FROM msc_interorg_ship_methods msim '||
3751: ' , msc_regions_temp mrt '||
3752: -- ' , fnd_common_lookups fnd '||
3753: ' WHERE mrt.session_id = :x_session_id '||
3754: ' AND msim.plan_id = -1 '||

Line 4955: FROM msc_interorg_ship_methods mism,

4951: )
4952: IS
4953: SELECT mism.ship_method, mism.intransit_time,
4954: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4955: FROM msc_interorg_ship_methods mism,
4956: msc_regions_temp mrt
4957: WHERE mism.plan_id = -1
4958: AND mism.from_location_id = c_from_location_id
4959: AND mism.sr_instance_id = c_from_instance_id

Line 5027: from msc_interorg_ship_methods

5023: -1,
5024: intransit_time,
5025: ship_method,
5026: 100
5027: from msc_interorg_ship_methods
5028: where from_organization_id = p_from_organization_id
5029: and to_organization_id = p_to_organization_id
5030: and sr_instance_id = p_from_instance_id
5031: and sr_instance_id2 = p_to_instance_id

Line 5079: from msc_interorg_ship_methods

5075: -1,
5076: intransit_time,
5077: ship_method,
5078: 100
5079: from msc_interorg_ship_methods
5080: where plan_id = -1
5081: and from_location_id = l_from_location_id
5082: and sr_instance_id = p_from_instance_id
5083: and to_location_id = l_to_location_id

Line 8519: FROM msc_interorg_ship_methods mism,

8515: CURSOR c_lead_time
8516: IS
8517: SELECT intransit_time,
8518: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
8519: FROM msc_interorg_ship_methods mism,
8520: msc_regions_temp mrt
8521: WHERE mism.plan_id = -1
8522: AND mism.from_location_id = p_from_loc_id
8523: AND mism.sr_instance_id = p_from_instance_id

Line 8536: FROM msc_interorg_ship_methods mism,

8532: CURSOR c_default_lead_time
8533: IS
8534: SELECT ship_method, intransit_time,
8535: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
8536: FROM msc_interorg_ship_methods mism,
8537: msc_regions_temp mrt
8538: WHERE mism.plan_id = -1
8539: AND mism.from_location_id = p_from_loc_id
8540: AND mism.sr_instance_id = p_from_instance_id

Line 8554: FROM msc_interorg_ship_methods mism,

8550: CURSOR c_supplier_lead_time
8551: IS
8552: SELECT intransit_time,
8553: mrt.region_type region_level -- collection has already translated data
8554: FROM msc_interorg_ship_methods mism,
8555: msc_regions_temp mrt
8556: WHERE mism.plan_id = -1
8557: AND mism.to_location_id = p_to_loc_id
8558: AND mism.sr_instance_id2 = p_to_instance_id

Line 8571: FROM msc_interorg_ship_methods mism,

8567: CURSOR c_supplier_default_lead_time
8568: IS
8569: SELECT ship_method, intransit_time,
8570: mrt.region_type region_level -- collection has already translated data
8571: FROM msc_interorg_ship_methods mism,
8572: msc_regions_temp mrt
8573: WHERE mism.plan_id = -1
8574: AND mism.to_location_id = p_to_loc_id
8575: AND mism.sr_instance_id2 = p_to_instance_id

Line 8610: FROM msc_interorg_ship_methods

8606:
8607: IF x_ship_method IS NOT NULL THEN
8608: SELECT intransit_time
8609: INTO x_intransit_time
8610: FROM msc_interorg_ship_methods
8611: WHERE plan_id = -1
8612: AND from_location_id = p_from_loc_id
8613: AND sr_instance_id = p_from_instance_id
8614: AND to_location_id = p_to_loc_id

Line 8621: FROM msc_interorg_ship_methods

8617: AND rownum = 1;
8618: ELSE
8619: SELECT ship_method, intransit_time
8620: INTO x_ship_method, x_intransit_time
8621: FROM msc_interorg_ship_methods
8622: WHERE plan_id = -1
8623: AND from_location_id = p_from_loc_id
8624: AND sr_instance_id = p_from_instance_id
8625: AND to_location_id = p_to_loc_id