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_OTM_REF_DATA_GEN_PKG dependencies on WSH_DELIVERY_LEGS

Line 91: WSH_DELIVERY_LEGS WDL,

87: SELECT HOU.ORGANIZATION_ID
88: FROM HR_ALL_ORGANIZATION_UNITS HOU,
89: WSH_LOCATIONS WL,
90: WSH_NEW_DELIVERIES WND,
91: WSH_DELIVERY_LEGS WDL,
92: WSH_TRIP_STOPS WTS
93: WHERE WTS.STOP_ID = p_stop_id
94: AND HOU.LOCATION_ID = WL.SOURCE_LOCATION_ID
95: AND WL.LOCATION_SOURCE_CODE = 'HR'

Line 121: WSH_DELIVERY_LEGS WDL,

117: HZ_PARTIES HP,
118: HZ_PARTY_SITES HPS,
119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,
121: WSH_DELIVERY_LEGS WDL,
122: WSH_TRIP_STOPS WTS,
123: WSH_DELIVERY_ASSIGNMENTS WDA,
124: WSH_DELIVERY_DETAILS WDD
125: WHERE WTS.STOP_ID = p_stop_id

Line 672: FROM WSH_DELIVERY_LEGS WDL,

668: l_loc_exists VARCHAR2(1);
669: -- cursors
670: cursor l_get_del_csr is
671: SELECT DISTINCT WDL.DELIVERY_ID
672: FROM WSH_DELIVERY_LEGS WDL,
673: WSH_TRIP_STOPS WTS,
674: WSH_OTM_LOCATIONS_GTMP WLT
675: WHERE WTS.TRIP_ID = WLT.LOCATION_ID
676: AND WLT.LOCATION_TYPE = 'TRIP'