DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 2337: from wsh_delivery_assignments a,

2333: CURSOR c_delivery_info is
2334: SELECT a.delivery_id
2335: , d.waybill
2336: , d.ultimate_dropoff_date
2337: from wsh_delivery_assignments a,
2338: wsh_delivery_details dd,
2339: wsh_new_deliveries d
2340: where a.delivery_detail_id = dd.delivery_detail_id
2341: and d.delivery_id = a.delivery_id

Line 2835: FROM wsh_delivery_details dd, wsh_delivery_assignments da

2831: -- Bug 3764091 Added NOT EXISTS to the cursor below so that wdd which is already synchronized to PO
2832: -- side is not inserted again in rcv_transactions_interface.
2833: CURSOR c_detail_in_delivery is
2834: SELECT dd.delivery_detail_id, dd.source_line_id
2835: FROM wsh_delivery_details dd, wsh_delivery_assignments da
2836: WHERE dd.delivery_detail_id = da.delivery_detail_id
2837: AND da.delivery_id = l_delivery_id
2838: AND NVL(dd.inv_interfaced_flag , 'N') = 'Y'
2839: AND dd.container_flag = 'N'