APPS.MRP_SCATP_PVT dependencies on MTL_INTERORG_SHIP_METHODS

Line 11: FROM mtl_interorg_ship_methods

7: BEGIN
8:
9: SELECT ship_method
10: INTO l_ship_method
11: FROM mtl_interorg_ship_methods
12: WHERE from_location_id = p_from_location_id
13: AND to_location_id = p_to_location_id
14: AND default_flag = 1
15: AND rownum = 1;

Line 31: FROM mtl_interorg_ship_methods

27: BEGIN
28:
29: SELECT intransit_time
30: INTO l_intransit_time
31: FROM mtl_interorg_ship_methods
32: WHERE from_location_id = p_from_location_id
33: AND to_location_id = p_to_location_id
34: AND default_flag = 1
35: AND rownum = 1;

Line 61: from mtl_interorg_ship_methods

57: END IF;
58:
59: select ship_method
60: into l_ship_method
61: from mtl_interorg_ship_methods
62: where from_organization_id = p_from_org_id
63: and to_organization_id = p_to_org_id
64: and default_flag = 1
65: and rownum = 1;

Line 89: from mtl_interorg_ship_methods

85:
86: BEGIN
87: select intransit_time
88: into l_intransit_time
89: from mtl_interorg_ship_methods
90: where from_organization_id = p_from_org_id
91: and to_organization_id = p_to_org_id
92: and ship_method = p_source_ship_method
93: and rownum = 1;

Line 108: from mtl_interorg_ship_methods

104:
105: BEGIN
106: select intransit_time
107: into l_intransit_time
108: from mtl_interorg_ship_methods
109: where from_organization_id = p_from_org_id
110: and to_organization_id = p_to_org_id
111: and default_flag = 1
112: and rownum = 1;