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_SATP_FUNC dependencies on MTL_INTERORG_SHIP_METHODS

Line 64: from mtl_interorg_ship_methods

60:
61: BEGIN
62: select intransit_time
63: into l_intransit_time
64: from mtl_interorg_ship_methods
65: where from_location_id = p_from_location_id
66: and to_location_id = p_to_location_id
67: and ship_method = p_ship_method
68: and rownum = 1;

Line 77: FROM mtl_interorg_ship_methods mism,

73: -- bug 2974334. Change the SQL into static.
74: SELECT intransit_time,
75: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
76: INTO l_intransit_time, l_level
77: FROM mtl_interorg_ship_methods mism,
78: msc_regions_temp mrt
79: WHERE mism.from_location_id = p_from_location_id
80: AND mism.ship_method = p_ship_method
81: AND mism.to_region_id = mrt.region_id

Line 107: FROM mtl_interorg_ship_methods

103: BEGIN
104: BEGIN
105: SELECT ship_method
106: INTO l_ship_method
107: FROM mtl_interorg_ship_methods
108: WHERE from_location_id = p_from_location_id
109: AND to_location_id = p_to_location_id
110: AND default_flag = 1
111: AND rownum = 1;

Line 120: FROM mtl_interorg_ship_methods mism,

116: -- bug 2974334. Change the SQL into static.
117: SELECT ship_method,
118: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
119: INTO l_ship_method, l_level
120: FROM mtl_interorg_ship_methods mism,
121: msc_regions_temp mrt
122: WHERE mism.from_location_id = p_from_location_id
123: AND mism.to_region_id = mrt.region_id
124: AND mrt.session_id = p_session_id

Line 147: from mtl_interorg_ship_methods

143: BEGIN
144: -- bug 2974334. Change the SQL into static.
145: select ship_method
146: into l_ship_method
147: from mtl_interorg_ship_methods
148: where from_organization_id = p_from_org_id
149: and to_organization_id = p_to_org_id
150: and default_flag = 1
151: and rownum = 1;

Line 173: FROM mtl_interorg_ship_methods

169: BEGIN
170: BEGIN
171: SELECT intransit_time
172: INTO l_intransit_time
173: FROM mtl_interorg_ship_methods
174: WHERE from_location_id = p_from_location_id
175: AND to_location_id = p_to_location_id
176: AND default_flag = 1
177: AND rownum = 1;

Line 186: FROM mtl_interorg_ship_methods mism,

182: -- bug 2974334. Change the SQL into static.
183: SELECT intransit_time,
184: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
185: INTO l_intransit_time, l_level
186: FROM mtl_interorg_ship_methods mism,
187: msc_regions_temp mrt
188: WHERE mism.from_location_id = p_from_location_id
189: AND mism.default_flag = 1
190: AND mism.to_region_id = mrt.region_id

Line 212: from mtl_interorg_ship_methods

208: BEGIN
209: -- bug 2974334. Change the SQL into static.
210: select intransit_time
211: into l_intransit_time
212: from mtl_interorg_ship_methods
213: where from_organization_id = p_from_org_id
214: and to_organization_id = p_to_org_id
215: and default_flag = 1
216: and rownum = 1;

Line 2686: FROM mtl_interorg_ship_methods mism,

2682: CURSOR c_lead_time
2683: IS
2684: SELECT intransit_time,
2685: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
2686: FROM mtl_interorg_ship_methods mism,
2687: msc_regions_temp mrt
2688: WHERE mism.from_location_id = p_from_loc_id
2689: AND mism.ship_method = x_ship_method
2690: AND mism.to_region_id = mrt.region_id

Line 2701: FROM mtl_interorg_ship_methods mism,

2697: CURSOR c_default_lead_time
2698: IS
2699: SELECT ship_method, intransit_time,
2700: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
2701: FROM mtl_interorg_ship_methods mism,
2702: msc_regions_temp mrt
2703: WHERE mism.from_location_id = p_from_loc_id
2704: AND mism.default_flag = 1
2705: AND mism.to_region_id = mrt.region_id

Line 2735: FROM mtl_interorg_ship_methods

2731: BEGIN
2732: IF x_ship_method IS NOT NULL THEN
2733: SELECT intransit_time
2734: INTO x_intransit_time
2735: FROM mtl_interorg_ship_methods
2736: WHERE from_location_id = p_from_loc_id
2737: AND to_location_id = p_to_loc_id
2738: AND ship_method = x_ship_method
2739: AND rownum = 1;

Line 2743: FROM mtl_interorg_ship_methods

2739: AND rownum = 1;
2740: ELSE
2741: SELECT ship_method, intransit_time
2742: INTO x_ship_method, x_intransit_time
2743: FROM mtl_interorg_ship_methods
2744: WHERE from_location_id = p_from_loc_id
2745: AND to_location_id = p_to_loc_id
2746: AND default_flag = 1
2747: AND rownum = 1;

Line 2774: from mtl_interorg_ship_methods

2770: BEGIN
2771: IF x_ship_method IS NOT NULL THEN
2772: select intransit_time
2773: into x_intransit_time
2774: from mtl_interorg_ship_methods
2775: where from_organization_id = p_from_org_id
2776: and to_organization_id = p_to_org_id
2777: and ship_method = x_ship_method
2778: and rownum = 1;

Line 2782: from mtl_interorg_ship_methods

2778: and rownum = 1;
2779: ELSE
2780: select ship_method, intransit_time
2781: into x_ship_method, x_intransit_time
2782: from mtl_interorg_ship_methods
2783: where from_organization_id = p_from_org_id
2784: and to_organization_id = p_to_org_id
2785: and default_flag = 1
2786: and rownum = 1;