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_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 71: FROM wsh_delivery_assignments_v wda,

67: WHERE delivery_id = c_delivery_id;
68:
69: CURSOR cont_not_recv_cur(l_delivery_id NUMBER, l_delivery_interface_id NUMBER) IS
70: SELECT wda.delivery_detail_id
71: FROM wsh_delivery_assignments_v wda,
72: wsh_delivery_details wdd
73: where wdd.delivery_detail_id = wda.delivery_detail_id
74: and wdd.container_flag = 'Y'
75: and wda.parent_delivery_detail_id IS NULL

Line 92: FROM wsh_delivery_assignments_v wda

88: AND WDDI.INTERFACE_ACTION_CODE = '94X_INBOUND';
89:
90: CURSOR cont_contents_cur(l_del_detail_id NUMBER) IS
91: SELECT wda.delivery_detail_id
92: FROM wsh_delivery_assignments_v wda
93: WHERE parent_delivery_detail_id IS NOT NULL
94: START WITH wda.delivery_detail_id = l_del_detail_id
95: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
96: