APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DEL_ASSGN_INTERFACE

Line 198: wsh_del_assgn_interface wdai

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'))
202: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 257: - This procedure updates the wsh_del_assgn_interface table.

253: x_return_status - return status of API
254: DESCRIPTION :
255: - This procedure is called in the Inbound Map, to relate the SHIPITEM records
256: with the SHIPUNIT/CONTAINER records through the parent_detail_interface_id.
257: - This procedure updates the wsh_del_assgn_interface table.
258: - This takes the parent_delivery_detail_id and parent_detail_interface_id.
259: - For those records which have parent_delivery_detail_id is equal to the
260: parameter value, the parent_detail_interface_id is updated with the give
261: value.

Line 295: UPDATE wsh_del_assgn_interface

291: END IF;
292:
293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
294:
295: UPDATE wsh_del_assgn_interface
296: SET parent_detail_interface_id = p_parent_detail_interface_id
297: WHERE parent_delivery_detail_id = p_parent_delivery_detail_id;
298:
299: IF (SQL%NOTFOUND) THEN

Line 632: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi

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'

Line 1632: FROM wsh_del_details_interface wddi, wsh_del_assgn_interface wdai

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')

Line 4868: FROM wsh_del_assgn_interface wdai, wsh_del_details_interface wddi

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';

Line 5336: wsh_del_assgn_interface wdai,

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
5340: where wdd1.source_code = 'OE'

Line 5355: wsh_del_assgn_interface wdai,

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,
5359: po_requisition_headers_all ph