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.WSH_WSHRDMBL_XMLP_PKG dependencies on WSH_TRIP_STOPS

Line 11: WSH_TRIP_STOPS WTS

7: ORGANIZATION_NAME
8: INTO L_SHIPPER_NAME
9: FROM
10: WSH_SHIP_FROM_ORGS_V WSFO,
11: WSH_TRIP_STOPS WTS
12: WHERE TRIP_ID = P_TRIP_ID
13: AND WTS.STOP_LOCATION_ID = WSFO.LOCATION_ID
14: AND WTS.STOP_SEQUENCE_NUMBER = (
15: SELECT

Line 18: WSH_TRIP_STOPS

14: AND WTS.STOP_SEQUENCE_NUMBER = (
15: SELECT
16: MIN(STOP_SEQUENCE_NUMBER)
17: FROM
18: WSH_TRIP_STOPS
19: WHERE TRIP_ID = WTS.TRIP_ID );
20: RETURN L_SHIPPER_NAME;
21: EXCEPTION
22: WHEN NO_DATA_FOUND THEN

Line 32: WSH_TRIP_STOPS WTS,

28: ORGANIZATION_NAME
29: INTO L_SHIPPER_NAME
30: FROM
31: WSH_SHIP_FROM_ORGS_V WSFO,
32: WSH_TRIP_STOPS WTS,
33: WSH_NEW_DELIVERIES WND,
34: WSH_DELIVERY_LEGS WDL
35: WHERE WTS.TRIP_ID = P_TRIP_ID
36: AND WTS.STOP_ID = CF_SHIPPER_NAMEFORMULA.STOP_ID

Line 45: WSH_TRIP_STOPS

41: AND WTS.STOP_SEQUENCE_NUMBER = (
42: SELECT
43: MIN(STOP_SEQUENCE_NUMBER)
44: FROM
45: WSH_TRIP_STOPS
46: WHERE TRIP_ID = WTS.TRIP_ID )
47: AND ROWNUM = 1;
48: RETURN L_SHIPPER_NAME;
49: EXCEPTION