DBA Data[Home] [Help]

APPS.MSC_DRP_UTIL dependencies on MSC_INTERORG_SHIP_METHODS

Line 76: from msc_interorg_ship_methods

72: CURSOR cost_c is
73: select COST_PER_WEIGHT_UNIT, COST_PER_VOLUME_UNIT,
74: SHIPMENT_WEIGHT_UOM, SHIPMENT_VOLUME_UOM,
75: WEIGHT_UOM, VOLUME_UOM
76: from msc_interorg_ship_methods
77: where from_organization_id = p_from_org_id
78: and sr_instance_id = p_from_inst_id
79: and to_organization_id = p_to_org_id
80: and sr_instance_id2 = p_to_inst_id

Line 163: from msc_interorg_ship_methods

159: p_source_sr_instance_id in number default null) is
160: p_associate_type number;
161: cursor lead_time_c is
162: select intransit_time
163: from msc_interorg_ship_methods
164: where from_organization_id = p_from_org
165: and to_organization_id = p_to_org
166: and sr_instance_id = p_inst_id
167: and ship_method = p_ship_method