APPS.MST_AUDIT_REP_EXCP dependencies on WSH_LOCATIONS

Line 57: FROM WSH_LOCATIONS loc,

53: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 704,
54: location_id,
55: userIdIn, userIdIn,-1,sysdate, sysdate, 3
56: FROM (SELECT distinct wsh_location_id as location_id
57: FROM WSH_LOCATIONS loc,
58: MST_DELIVERY_DETAILS det
59: WHERE det.plan_id = plan_idIn
60: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
61: AND ( det.ship_from_location_id = loc.wsh_location_id

Line 67: WSH_LOCATIONS loc

63: AND ( latitude is null OR longitude is null)
64: UNION
65: SELECT distinct wsh_location_id as location_id
66: FROM FTE_LOCATION_PARAMETERS param,
67: WSH_LOCATIONS loc
68: WHERE loc.wsh_location_id = param.location_id
69: AND ( param.consolidation_allowed = 'Y'
70: OR param.deconsolidation_allowed = 'Y'
71: OR param.crossdocking_allowed = 'Y')

Line 982: WSH_LOCATIONS loc1,

978: det.ship_to_location_id ship_to_location_id,
979: latest_acceptable_date, earliest_pickup_date
980: FROM MST_DELIVERY_DETAILS det,
981: MST_DELIVERY_ASSIGNMENTS da,
982: WSH_LOCATIONS loc1,
983: WSH_LOCATIONS loc2
984: WHERE det.plan_id = plan_idIn
985: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
986: AND det.delivery_detail_id = da.delivery_detail_id (+)

Line 983: WSH_LOCATIONS loc2

979: latest_acceptable_date, earliest_pickup_date
980: FROM MST_DELIVERY_DETAILS det,
981: MST_DELIVERY_ASSIGNMENTS da,
982: WSH_LOCATIONS loc1,
983: WSH_LOCATIONS loc2
984: WHERE det.plan_id = plan_idIn
985: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
986: AND det.delivery_detail_id = da.delivery_detail_id (+)
987: AND parent_delivery_detail_id is null

Line 1297: FROM WSH_LOCATIONS

1293: --we need to use lat/long method
1294: BEGIN
1295: SELECT NVL(latitude,0), NVL(longitude,0)
1296: INTO lat_1, lon_1
1297: FROM WSH_LOCATIONS
1298: WHERE wsh_location_id = ship_from;
1299: -- debug_output('ship_from=' || ship_from || ', lat=' || lat_1 || ', long=' || lon_1);
1300: EXCEPTION WHEN no_data_found then
1301: debug_output('Error: no entry in distance table and latitude/longitude is null for location_id = ' || ship_from);

Line 1308: FROM WSH_LOCATIONS

1304:
1305: BEGIN
1306: SELECT NVL(latitude,0), NVL(longitude,0)
1307: INTO lat_2, lon_2
1308: FROM WSH_LOCATIONS
1309: WHERE wsh_location_id = ship_to;
1310: -- debug_output('ship_to=' || ship_to || ', lat=' || lat_2 || ', long=' || lon_2);
1311:
1312: EXCEPTION WHEN no_data_found then