[Home] [Help]
193: wddi.EARLIEST_PICKUP_DATE ,
194: wddi.LATEST_PICKUP_DATE ,
195: wddi.EARLIEST_DROPOFF_DATE ,
196: wddi.LATEST_DROPOFF_DATE
197: FROM wsh_del_details_interface wddi,
198: wsh_del_assgn_interface wdai
199: WHERE wddi.delivery_detail_id= nvl(l_detail_id, wddi.delivery_detail_id)
200: -- TPW - Distributed changes
201: AND nvl(wddi.source_header_number,'-99') = nvl(l_header_number, nvl(wddi.source_header_number,'-99'))
326: x_del_detail_id - Delivery_Detail_ID of the detail created
327: - using Create_Shipment_Lines api
328: x_return_status - return status of API
329: DESCRIPTION :
330: - This procedure is used to process the delivery details in the wsh_del_details_interface
331: table.
332: - If the action is CREATE, then we take the interface record columns and call
333: the 'Create_Shipment_Lines' api.
334: - If the action is UPDATE, then we do the following:
628: wddi.source_header_number,
629: wdai.delivery_detail_id,
630: decode(wddi.container_flag, 'Y', wdai.parent_delivery_detail_id,null) parent_delivery_detail_id,
631: wddi.container_flag
632: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi
633: WHERE wdai.delivery_interface_id = p_delivery_interface_id
634: AND wdai.delivery_detail_interface_id = wddi.delivery_detail_interface_id
635: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND'
636: AND WDDI.INTERFACE_ACTION_CODE = '94X_INBOUND'
1628: --Cursors
1629: --TPW - Distributed changes
1630: CURSOR c_det_count_cur(p_header_number NUMBER, p_detail_id NUMBER, p_dlvy_int_id NUMBER) IS
1631: SELECT COUNT(*)
1632: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai
1633: WHERE wddi.delivery_Detail_interface_id = wdai.delivery_detail_interface_id
1634: AND wdai.delivery_interface_id = p_dlvy_int_id
1635: AND wddi.delivery_detail_id=p_detail_id
1636: AND nvl(wddi.source_header_number,'-99') = nvl(p_header_number,'-99')
1696: END IF;
1697:
1698: /* New Logic for splitting at supplier instance 945 inbound. kvenkate.
1699: For a given delivery_detail_id ,
1700: if more than one record exists in wsh_del_details_interface, then
1701: if those records have the same not null source_line_id, then do not split.
1702: if those records have distinct source_line_id, then split. */
1703:
1704: -- TPW - Distributed changes
4864: AND wdd.organization_id = p_del_det_int_rec.organization_id;
4865:
4866: CURSOR intf_parent_det_cur IS
4867: SELECT wdai.parent_delivery_detail_id, wddi.container_flag
4868: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi
4869: WHERE wdai.delivery_detail_interface_id = p_del_det_int_rec.delivery_detail_interface_id
4870: AND wdai.delivery_detail_interface_id = wddi.delivery_detail_interface_id
4871: AND wddi.INTERFACE_ACTION_CODE = '94X_INBOUND'
4872: AND WDAI.INTERFACE_ACTION_CODE = '94X_INBOUND';
5331: AND wdd.delivery_detail_id = wda.delivery_detail_id
5332: AND wdd.released_status in ('R','B','X')
5333: AND wdd.delivery_detail_id in (
5334: select wdd1.delivery_detail_id
5335: from wsh_del_details_interface wddi,
5336: wsh_del_assgn_interface wdai,
5337: wsh_shipment_batches wsb,
5338: wsh_transactions_history wth,
5339: wsh_delivery_details wdd1
5350: AND wth.document_type = 'SR'
5351: AND wth.document_direction = 'O'
5352: UNION
5353: SELECT wdd1.delivery_detail_id
5354: FROM wsh_del_details_interface wddi,
5355: wsh_del_assgn_interface wdai,
5356: wsh_delivery_details wdd1,
5357: oe_order_lines_all ol,
5358: po_requisition_lines_all pl,