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_CUSTOM_PUB dependencies on WSH_NEW_DELIVERIES

Line 15: p_delivery_info IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

11:
12: FUNCTION Delivery_Name
13: (
14: p_delivery_id IN NUMBER,
15: p_delivery_info IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
16: ) RETURN VARCHAR2 IS
17:
18: BEGIN
19:

Line 175: wsh_new_deliveries wnd,

171: sum(nvl(wdd.shipped_quantity,0))
172: FROM
173: wsh_delivery_details wdd,
174: wsh_delivery_assignments wda,
175: wsh_new_deliveries wnd,
176: mtl_system_items msi
177: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
178: AND wda.delivery_id = wnd.delivery_id
179: AND wnd.status_code in ('IT','CL')

Line 275: wsh_new_deliveries wnd,

271: sum(nvl(wdd.requested_quantity,0))
272: FROM
273: wsh_delivery_details wdd,
274: wsh_delivery_assignments wda,
275: wsh_new_deliveries wnd,
276: mtl_system_items msi
277: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
278: AND wdd.date_scheduled < sysdate
279: --AND wdd.date_scheduled > p_last_notif_date