DBA Data[Home] [Help]

APPS.MST_AUDIT_REP_EXCP dependencies on MTL_INTERORG_SHIP_METHODS

Line 1252: FROM MTL_INTERORG_SHIP_METHODS sm,

1248: BEGIN
1249: --check LTL and Parcel
1250: SELECT NVL(MIN(NVL(CONV_TO_UOM(sm.INTRANSIT_TIME,sm.TIME_UOM_CODE,tp_time_uom,0),99999)),99999)
1251: INTO minimumTransitTime
1252: FROM MTL_INTERORG_SHIP_METHODS sm,
1253: WSH_REGION_LOCATIONS rl1,
1254: WSH_REGION_LOCATIONS rl2
1255: WHERE rl1.location_id = ship_from
1256: AND rl2.location_id = ship_to