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_WSHRDBSR_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 290: WSH_DELIVERY_DETAILS

286: SUM(NVL(SHIPPED_QUANTITY
287: ,0))
288: INTO SHP_QTY
289: FROM
290: WSH_DELIVERY_DETAILS
291: WHERE ORGANIZATION_ID = ORGANIZATION_ID_V
292: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
293: AND SOURCE_HEADER_NUMBER = SOURCE_HEADER_NUMBER_V
294: AND SOURCE_HEADER_TYPE_NAME = ORDER_TYPE

Line 307: WSH_DELIVERY_DETAILS

303: SUM(NVL(SHIPPED_QUANTITY
304: ,0))
305: INTO SHP_QTY
306: FROM
307: WSH_DELIVERY_DETAILS
308: WHERE ORGANIZATION_ID = ORGANIZATION_ID_V
309: AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
310: AND SOURCE_HEADER_NUMBER = SOURCE_HEADER_NUMBER_V
311: AND SOURCE_HEADER_TYPE_NAME = ORDER_TYPE

Line 329: WSH_DELIVERY_DETAILS WDD,

325: CURSOR C_LAST_SHIPPED_DATE(P_ORGANIZATION_ID IN NUMBER,P_SOURCE_HEADER_NUMBER IN VARCHAR2) IS
326: SELECT
327: MAX(WTS.ACTUAL_DEPARTURE_DATE) LAST_SHIPPED_DATE
328: FROM
329: WSH_DELIVERY_DETAILS WDD,
330: WSH_DELIVERY_ASSIGNMENTS_V WDA,
331: WSH_DELIVERY_LEGS WDL,
332: WSH_TRIP_STOPS WTS
333: WHERE WDD.RELEASED_STATUS in ( 'C' , 'I' )