DBA Data[Home] [Help]

APPS.WSH_OTM_OUTBOUND dependencies on WSH_DELIVERY_DETAILS

Line 930: wsh_delivery_details wdd

926:
927: CURSOR get_customer_id (p_delivery_id NUMBER) IS
928: SELECT wdd.customer_id, count(*) cnt
929: FROM wsh_delivery_assignments wda,
930: wsh_delivery_details wdd
931: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
932: AND wda.delivery_id = p_delivery_id
933: AND wdd.container_flag = 'N'
934: GROUP BY customer_id

Line 1056: ||' from wsh_new_deliveries wnd, wsh_delivery_details wdd , wsh_delivery_assignments wda'

1052: ||'wdd.container_flag,'
1053: ||'wda.parent_delivery_detail_id,'
1054: ||'wdd.cust_po_number,'
1055: ||'wdd.source_header_number,''CUST_PO'',''SO_NUM'', wda.delivery_id,nvl(wdd.NET_WEIGHT,0))'
1056: ||' from wsh_new_deliveries wnd, wsh_delivery_details wdd , wsh_delivery_assignments wda'
1057: ||' where wdd.delivery_detail_id(+) = wda.delivery_detail_id '
1058: ||' and wnd.delivery_id = wda.delivery_id(+) '
1059: ||' and wnd.delivery_id in (';
1060: --Bug 7408338