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 21: p_delivery_info IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type

17:
18: FUNCTION Delivery_Name
19: (
20: p_delivery_id IN NUMBER,
21: p_delivery_info IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
22: ) RETURN VARCHAR2 IS
23:
24: BEGIN
25:

Line 181: wsh_new_deliveries wnd,

177: sum(nvl(wdd.shipped_quantity,0))
178: FROM
179: wsh_delivery_details wdd,
180: wsh_delivery_assignments wda,
181: wsh_new_deliveries wnd,
182: mtl_system_items msi
183: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
184: AND wda.delivery_id = wnd.delivery_id
185: AND wnd.status_code in ('IT','CL')

Line 281: wsh_new_deliveries wnd,

277: sum(nvl(wdd.requested_quantity,0))
278: FROM
279: wsh_delivery_details wdd,
280: wsh_delivery_assignments wda,
281: wsh_new_deliveries wnd,
282: mtl_system_items msi
283: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
284: AND wdd.date_scheduled < sysdate
285: --AND wdd.date_scheduled > p_last_notif_date