APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_INBOUND_TXN_HISTORY

Line 422: -- last_update_date from WSH_INBOUND_TXN_HISTORY, this API

418: -- Purpose : This procedure is used to determine whether delivery characteristics have
419: -- changed since the time the routing response was generated.
420: -- This API checks the last_update_date on all the tables related to the
421: -- routing response and if any of the dates is greater than the
422: -- last_update_date from WSH_INBOUND_TXN_HISTORY, this API
423: -- returns TRUE, else it returns FALSE
424: --
425: -- Version : 1.0
426: --

Line 440: FROM wsh_inbound_txn_history wth, wsh_new_deliveries wnd

436: IS
437: --
438: CURSOR c_GetDelId(p_respNum VARCHAR2) IS
439: SELECT wth.shipment_header_id, wth.last_update_date, wnd.last_update_date
440: FROM wsh_inbound_txn_history wth, wsh_new_deliveries wnd
441: WHERE receipt_number like p_respNum
442: AND shipment_header_id = wnd.delivery_id
443: AND transaction_type = 'ROUTING_RESPONSE'
444: ORDER BY NVL(revision_number, -99) DESC;

Line 490: l_deliveryId WSH_INBOUND_TXN_HISTORY.shipment_header_id%TYPE;

486: WHERE wnd.organization_id = wocs.organization_id
487: AND wcs.carrier_id = wnd.carrier_id
488: AND wnd.delivery_id = p_delId;
489: --
490: l_deliveryId WSH_INBOUND_TXN_HISTORY.shipment_header_id%TYPE;
491: l_wndUpdateDate DATE;
492: l_wdaUpdateDate DATE;
493: l_wddUpdateDate DATE;
494: l_wdlUpdateDate DATE;