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.

[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 549: , wsh_delivery_assignments_v wda

545: /*CURSOR c_wdd_lpn IS
546: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
547: , wdd1.subinventory
548: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
549: , wsh_delivery_assignments_v wda
550: WHERE wdd2.delivery_detail_id = p_transaction_id
551: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
552: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
553: */

Line 562: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda

558: AND wdd.lpn_id = wlpn.lpn_id;
559:
560: CURSOR c_wnd_lpn IS
561: SELECT DISTINCT wdd2.lpn_id, wdd1.organization_id /*8736862-added distinct*/
562: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda
563: , wsh_delivery_details wdd1, wsh_delivery_details wdd2
564: WHERE wnd.delivery_id = p_transaction_id
565: AND wnd.delivery_id = wda.delivery_id
566: AND wdd1.delivery_detail_id = wda.delivery_detail_id