DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_INTERORG_SHIP_METHODS

Line 347: FROM MSC_ST_INTERORG_SHIP_METHODS msism

343: msism.SHIPMENT_VOLUME,
344: msism.SHIPMENT_WEIGHT_UOM,
345: msism.SHIPMENT_VOLUME_UOM,
346: msism.LEADTIME_VARIABILITY
347: FROM MSC_ST_INTERORG_SHIP_METHODS msism
348: WHERE msism.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
349: /* Changed Refresh_id to Refresh_Number */
350: CURSOR c7 IS
351: SELECT msr.REGION_ID,

Line 1290: UPDATE msc_st_interorg_ship_methods msism

1286:
1287: END IF;
1288:
1289:
1290: UPDATE msc_st_interorg_ship_methods msism
1291: SET (shipment_weight, shipment_volume, shipment_weight_uom, shipment_volume_uom, leadtime_variability) =
1292: (SELECT shipment_weight, shipment_volume, shipment_weight_uom, shipment_volume_uom, leadtime_variability FROM
1293: msc_interorg_ship_methods mism
1294: WHERE mism.from_organization_id = msism.from_organization_id