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.MST_AUDIT_REP_EXCP dependencies on WSH_REGION_LOCATIONS

Line 146: WSH_REGION_LOCATIONS origReg,

142: delivery_detail_id, delivery_id
143: FROM ( SELECT DISTINCT det.delivery_detail_id AS delivery_detail_id, da.delivery_id AS delivery_id
144: FROM MST_DELIVERY_DETAILS det,
145: MST_DELIVERY_ASSIGNMENTS da,
146: WSH_REGION_LOCATIONS origReg,
147: WSH_REGION_LOCATIONS destReg
148: WHERE det.PLAN_ID = plan_idIn
149: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
150: AND det.delivery_detail_id = da.delivery_detail_id (+)

Line 147: WSH_REGION_LOCATIONS destReg

143: FROM ( SELECT DISTINCT det.delivery_detail_id AS delivery_detail_id, da.delivery_id AS delivery_id
144: FROM MST_DELIVERY_DETAILS det,
145: MST_DELIVERY_ASSIGNMENTS da,
146: WSH_REGION_LOCATIONS origReg,
147: WSH_REGION_LOCATIONS destReg
148: WHERE det.PLAN_ID = plan_idIn
149: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
150: AND det.delivery_detail_id = da.delivery_detail_id (+)
151: AND da.parent_delivery_detail_id is null

Line 1073: WSH_REGION_LOCATIONS origReg,

1069: --Should we use distance_level profile to choose which one?
1070: SELECT MIN(lm.distance)
1071: INTO distance
1072: FROM FTE_LOCATION_MILEAGES lm,
1073: WSH_REGION_LOCATIONS origReg,
1074: WSH_REGION_LOCATIONS destReg
1075: WHERE origReg.location_id = delivLine.ship_from_location_id
1076: AND destReg.location_id = delivLine.ship_to_location_id
1077: AND origReg.region_id = origin_id

Line 1074: WSH_REGION_LOCATIONS destReg

1070: SELECT MIN(lm.distance)
1071: INTO distance
1072: FROM FTE_LOCATION_MILEAGES lm,
1073: WSH_REGION_LOCATIONS origReg,
1074: WSH_REGION_LOCATIONS destReg
1075: WHERE origReg.location_id = delivLine.ship_from_location_id
1076: AND destReg.location_id = delivLine.ship_to_location_id
1077: AND origReg.region_id = origin_id
1078: AND destReg.region_id = destination_id;

Line 1240: -- FROM WSH_REGION_LOCATIONS rl1,

1236:
1237: -- Anuj says FTE_LANES is not going to be populated by TE
1238: -- CURSOR c_LTLParcel_transit_times IS
1239: -- SELECT lane_id, carrier_id, mode_of_transportation_code, lanes.transit_time, lanes.transit_time_uom
1240: -- FROM WSH_REGION_LOCATIONS rl1,
1241: -- WSH_REGION_LOCATIONS rl2,
1242: -- FTE_LANES lanes
1243: -- WHERE rl1.location_id = ship_from
1244: -- AND rl2.location_id = ship_to

Line 1241: -- WSH_REGION_LOCATIONS rl2,

1237: -- Anuj says FTE_LANES is not going to be populated by TE
1238: -- CURSOR c_LTLParcel_transit_times IS
1239: -- SELECT lane_id, carrier_id, mode_of_transportation_code, lanes.transit_time, lanes.transit_time_uom
1240: -- FROM WSH_REGION_LOCATIONS rl1,
1241: -- WSH_REGION_LOCATIONS rl2,
1242: -- FTE_LANES lanes
1243: -- WHERE rl1.location_id = ship_from
1244: -- AND rl2.location_id = ship_to
1245: -- AND lanes.ORIGIN_ID = rl1.region_id

Line 1253: WSH_REGION_LOCATIONS rl1,

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
1257: AND ( ship_from = sm.from_location_id AND ship_to = sm.to_location_id

Line 1254: WSH_REGION_LOCATIONS rl2

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
1257: AND ( ship_from = sm.from_location_id AND ship_to = sm.to_location_id
1258: OR (ship_from = sm.from_location_id AND rl2.region_id = sm.to_region_id)

Line 1273: WSH_REGION_LOCATIONS origReg,

1269: BEGIN
1270: SELECT MIN(CONV_TO_UOM(distTable.transit_time,distTable.transit_time_uom,tp_time_uom,0))
1271: INTO tl_minimumTransitTime
1272: FROM FTE_LOCATION_MILEAGES distTable,
1273: WSH_REGION_LOCATIONS origReg,
1274: WSH_REGION_LOCATIONS destReg
1275: WHERE origReg.location_id = ship_from
1276: AND destReg.location_id = ship_to
1277: AND origReg.region_id = distTable.origin_id

Line 1274: WSH_REGION_LOCATIONS destReg

1270: SELECT MIN(CONV_TO_UOM(distTable.transit_time,distTable.transit_time_uom,tp_time_uom,0))
1271: INTO tl_minimumTransitTime
1272: FROM FTE_LOCATION_MILEAGES distTable,
1273: WSH_REGION_LOCATIONS origReg,
1274: WSH_REGION_LOCATIONS destReg
1275: WHERE origReg.location_id = ship_from
1276: AND destReg.location_id = ship_to
1277: AND origReg.region_id = distTable.origin_id
1278: AND destReg.region_id = distTable.destination_id;