DBA Data[Home] [Help]

APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DELIVERY_DETAILS

Line 72: wsh_delivery_details wdd

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
76: and wda.delivery_id IS NOT NULL

Line 99: FROM wsh_delivery_details

95: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
96:
97: CURSOR det_qtys_cur(l_del_detail_id NUMBER) IS
98: SELECT requested_quantity, picked_quantity, container_flag
99: FROM wsh_delivery_details
100: WHERE delivery_detail_id = l_del_detail_id;
101:
102: --Bug 3346237:ENFORCE SHIP METHOD NOT ENFORCED WHILE SHIP CONFIRMING
103: --Created new cursor get_defer_interface_info to get defer_interface