eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_IB_UI_RECON_GRP dependencies on WSH_INBOUND_TXN_HISTORY

Line 185: from wsh_inbound_txn_history wth1,

181: --{
182: -- This cursor is not used anymore. Was added in the beginning of coding.
183: cursor l_parent_txn_sts_csr(p_shipment_header_id NUMBER) is
184: select 'Y'
185: from wsh_inbound_txn_history wth1,
186: wsh_inbound_txn_history wth2
187: where wth1.shipment_header_id = p_shipment_header_id
188: and wth1.transaction_type = 'ASN'
189: and wth2.parent_shipment_header_id = wth1.shipment_header_id;

Line 186: wsh_inbound_txn_history wth2

182: -- This cursor is not used anymore. Was added in the beginning of coding.
183: cursor l_parent_txn_sts_csr(p_shipment_header_id NUMBER) is
184: select 'Y'
185: from wsh_inbound_txn_history wth1,
186: wsh_inbound_txn_history wth2
187: where wth1.shipment_header_id = p_shipment_header_id
188: and wth1.transaction_type = 'ASN'
189: and wth2.parent_shipment_header_id = wth1.shipment_header_id;
190:

Line 471: from wsh_inbound_txn_history wth1,

467:
468: -- This is not used anymore. Was added in the beginning.
469: cursor l_parent_txn_sts_csr(p_shipment_header_id NUMBER) is
470: select 'Y'
471: from wsh_inbound_txn_history wth1,
472: wsh_inbound_txn_history wth2
473: where wth1.shipment_header_id = p_shipment_header_id
474: and wth1.transaction_type = 'ASN'
475: and wth2.parent_shipment_header_id = wth1.shipment_header_id;

Line 472: wsh_inbound_txn_history wth2

468: -- This is not used anymore. Was added in the beginning.
469: cursor l_parent_txn_sts_csr(p_shipment_header_id NUMBER) is
470: select 'Y'
471: from wsh_inbound_txn_history wth1,
472: wsh_inbound_txn_history wth2
473: where wth1.shipment_header_id = p_shipment_header_id
474: and wth1.transaction_type = 'ASN'
475: and wth2.parent_shipment_header_id = wth1.shipment_header_id;
476:

Line 1663: -- wsh_inbound_txn_history for that shipment_header_id.

1659: -- shipment_header_id from rcv_fte_lines_v. This cursor is used
1660: -- when the status of the receipt transaction is MATCHED_AND_CHILD_PENDING
1661: -- and user is trying to the match the pending transactions for the receipt.
1662: -- We query only those lines for which there are records present in
1663: -- wsh_inbound_txn_history for that shipment_header_id.
1664: cursor l_partial_shipment_line_csr (p_shipment_header_id IN NUMBER) is
1665: select distinct rfl.shipment_line_id,
1666: rfl.item_id,
1667: rfl.item_revision,

Line 1700: wsh_inbound_txn_history wth,

1696: porel.revision_num rel_revision_num
1697: from rcv_fte_lines_v rfl,
1698: mtl_system_items_vl msiv,
1699: po_releases_all porel,
1700: wsh_inbound_txn_history wth,
1701: rcv_shipment_lines rsl
1702: where rfl.shipment_header_id = p_shipment_header_id
1703: and rsl.shipment_header_id = p_shipment_header_id
1704: and rsl.shipment_line_id = rfl.shipment_line_id

Line 1721: from wsh_inbound_txn_history

1717:
1718: --Cursor to check the status of the transaction.
1719: cursor l_txn_status_csr (p_shipment_header_id IN NUMBER) is
1720: select 'Y'
1721: from wsh_inbound_txn_history
1722: where shipment_header_id = p_shipment_header_id
1723: and transaction_type = 'RECEIPT'
1724: and status like 'MATCHED%';
1725:

Line 1755: from wsh_inbound_txn_history

1751: -- this transaction type number is used in the UI to change
1752: -- query conditions on the delivery details.
1753: cursor l_txn_type_num_csr(p_shipment_header_id IN NUMBER, p_shipment_line_id IN NUMBER) is
1754: select DISTINCT DECODE(transaction_type, 'RECEIPT_ADD',1, 'RECEIPT_CORRECTION_POSITIVE',2,'RECEIPT_CORRECTION_NEGATIVE', 3, 'RTV',4, 'RTV_CORRECTION_NEGATIVE',5, 'RTV_CORRECTION_POSITIVE',6,7) txn_type
1755: from wsh_inbound_txn_history
1756: where shipment_line_id = p_shipment_line_id
1757: and shipment_header_id = p_shipment_header_id
1758: and transaction_type IN ('RECEIPT_ADD', 'RECEIPT_CORRECTION_POSITIVE', 'RECEIPT_CORRECTION_NEGATIVE', 'RTV', 'RTV_CORRECTION_NEGATIVE', 'RTV_CORRECTION_POSITIVE')
1759: order by txn_type;

Line 1775: from wsh_inbound_txn_history

1771:
1772: cursor l_lock_txn_hist_csr (p_shipment_header_id IN NUMBER,
1773: p_transaction_type IN VARCHAR2) is
1774: select 'X'
1775: from wsh_inbound_txn_history
1776: where shipment_header_id = p_shipment_header_id
1777: and transaction_type = p_transaction_type
1778: FOR UPDATE OF STATUS NOWAIT;
1779:

Line 1782: from wsh_inbound_txn_history

1778: FOR UPDATE OF STATUS NOWAIT;
1779:
1780: cursor l_max_with_txn_id_csr (p_shipment_header_id IN NUMBER, p_shipment_line_id IN NUMBER) is
1781: select max(transaction_id)
1782: from wsh_inbound_txn_history
1783: where shipment_line_id = p_shipment_line_id
1784: and shipment_header_id = p_shipment_header_id;
1785:
1786: l_lock_history_temp VARCHAR2(1);

Line 1793: from wsh_inbound_txn_history

1789: -- Cursor to check whether there was the receipt was recorded
1790: -- against an ASN or not
1791: cursor l_parent_txn_csr (p_shipment_header_id IN NUMBER) is
1792: select 'Y'
1793: from wsh_inbound_txn_history
1794: where shipment_header_id = p_shipment_header_id
1795: and transaction_type = 'ASN';
1796:
1797: l_parent_txn_csr_opened BOOLEAN := FALSE;

Line 2500: -- wsh_inbound_txn_history

2496: -- p_shipment_header_id Shipment Header Id of the transaction
2497: -- p_transaction_type transaction type (ASN or RECEIPT)
2498: -- p_object_version_number current object version of the
2499: -- transaction record in
2500: -- wsh_inbound_txn_history
2501: -- x_msg_count number of messages in the list
2502: -- x_msg_data text of messages
2503: -- x_return_status return status of the API
2504:

Line 2524: -- 3. Finally we call WSH_INBOUND_TXN_HISTORY_PKG.post_process

2520: -- > delivery details that ship_from_location_id as -1.
2521: -- > Then we call WSH_PO_CMG_PVT.Reapprove_PO as the
2522: -- > lines that have been re-opened need to be updated with the
2523: -- > latest information from po shipment lines.
2524: -- 3. Finally we call WSH_INBOUND_TXN_HISTORY_PKG.post_process
2525: -- to set the status of the transaction history record appropriately.
2526: --========================================================================
2527: PROCEDURE revert_matching(
2528: p_api_version_number IN NUMBER,

Line 2547: from wsh_inbound_txn_history

2543: -- that is matched. We do not want to allow reverting of ASN if the
2544: -- receipt is already matched or partially matched.
2545: cursor l_child_txn_sts_csr(p_shipment_header_id NUMBER) is
2546: select status, receipt_number
2547: from wsh_inbound_txn_history
2548: where shipment_header_id = p_shipment_header_id
2549: and transaction_type = 'RECEIPT';
2550:
2551: l_child_txn_sts VARCHAR2(32767);

Line 2576: from wsh_inbound_txn_history

2572: l_pkg_name VARCHAR2(32767);
2573:
2574: cursor l_parent_txn_exists_csr(p_shipment_header_id NUMBER) is
2575: select 'Y'
2576: from wsh_inbound_txn_history
2577: where shipment_header_id = p_shipment_header_id
2578: and transaction_type = 'ASN';
2579:
2580: l_parent_txn_exists_flag VARCHAR2(10) := 'N';

Line 2835: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);

2831: END IF;
2832: --
2833: --
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
2836: END IF;
2837: --
2838: --
2839: WSH_INBOUND_TXN_HISTORY_PKG.post_process(

Line 2839: WSH_INBOUND_TXN_HISTORY_PKG.post_process(

2835: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
2836: END IF;
2837: --
2838: --
2839: WSH_INBOUND_TXN_HISTORY_PKG.post_process(
2840: p_shipment_header_id => p_shipment_header_id,
2841: p_max_rcv_txn_id => NULL,
2842: p_action_code => 'REVERT',
2843: p_txn_type => p_transaction_type,

Line 2849: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_INBOUND_TXN_HISTORY_PKG.post_process is ', l_return_status);

2845: x_return_status => l_return_status);
2846: --
2847: --
2848: IF l_debug_on THEN
2849: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_INBOUND_TXN_HISTORY_PKG.post_process is ', l_return_status);
2850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2851: END IF;
2852: --
2853: --

Line 3233: -- wsh_inbound_txn_history

3229: -- process_corrections_and_rtv or not
3230: -- match the corrections, rtv transactions.
3231: -- p_object_version_number current object version of the
3232: -- transaction record in
3233: -- wsh_inbound_txn_history
3234: -- p_shipment_line_id_tab table of shipment line ids. If
3235: -- this table contains any ids, we need
3236: -- to delete all those records from
3237: -- wsh_inbound_txn_history.

Line 3237: -- wsh_inbound_txn_history.

3233: -- wsh_inbound_txn_history
3234: -- p_shipment_line_id_tab table of shipment line ids. If
3235: -- this table contains any ids, we need
3236: -- to delete all those records from
3237: -- wsh_inbound_txn_history.
3238: -- p_max_txn_id_tab table of max transaction ids for
3239: -- each shipment line id in
3240: -- wsh_inbound_txn_history.
3241: -- x_msg_count number of messages in the list

Line 3240: -- wsh_inbound_txn_history.

3236: -- to delete all those records from
3237: -- wsh_inbound_txn_history.
3238: -- p_max_txn_id_tab table of max transaction ids for
3239: -- each shipment line id in
3240: -- wsh_inbound_txn_history.
3241: -- x_msg_count number of messages in the list
3242: -- x_msg_data text of messages
3243: -- x_return_status return status of the API
3244:

Line 3257: -- 2. Then we call WSH_INBOUND_TXN_HISTORY_PKG.post_process API

3253: -- WSH_ASN_RECEIPT_PVT.Process_Matched_Txns to match the
3254: -- receipt or ASN. If the p_process_corr_rtv_flag is set to 'Y',
3255: -- then we call WSH_RCV_CORR_RTV_TXN_PKG.process_corrections_and_rtv
3256: -- to match the child transactions for the receipt.
3257: -- 2. Then we call WSH_INBOUND_TXN_HISTORY_PKG.post_process API
3258: -- to set the status of the transaction history record.
3259: -- appropriately
3260: -- 3. The APIs Process_Matched_Txns and process_corrections_and_rtv
3261: -- return the output parameter records that tell us whether

Line 3347: from wsh_inbound_txn_history

3343:
3344: -- { IB-Phase-2
3345: cursor l_get_ship_from_of_header_csr is
3346: select ship_from_location_id
3347: from wsh_inbound_txn_history
3348: where shipment_header_id = p_shipment_header_id
3349: AND transaction_type IN ('ASN','RECEIPT');
3350: -- } IB-Phase-2
3351:

Line 3607: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);

3603: --
3604: -- Debug Statements
3605: --
3606: IF l_debug_on THEN
3607: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.POST_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
3608: WSH_DEBUG_SV.log(l_module_name,'p_shipment_line_id_tab.count', p_shipment_line_id_tab.count);
3609: END IF;
3610: --
3611: -- This was added as a part of the changes to support matching of

Line 3615: -- what records need to be deleted from wsh_inbound_txn_history

3611: -- This was added as a part of the changes to support matching of
3612: -- partially matched transactions.
3613: -- The information stored in p_max_txn_id_tab is passed from the get_shipment_lines
3614: -- to the UI and then from UI to the match_shipments so that we know exactly
3615: -- what records need to be deleted from wsh_inbound_txn_history
3616: -- when matching a partially matched transaction.
3617: IF (p_shipment_line_id_tab.count > 0) THEN
3618: --{
3619: l_max_rcv_txn_id := -1;

Line 3627: delete from wsh_inbound_txn_history

3623: IF l_debug_on THEN
3624: WSH_DEBUG_SV.log(l_module_name,'p_shipment_line_id_tab(i)', p_shipment_line_id_tab(i));
3625: WSH_DEBUG_SV.log(l_module_name,'p_max_txn_id_tab(i)', p_max_txn_id_tab(i));
3626: END IF;
3627: delete from wsh_inbound_txn_history
3628: where shipment_line_id = p_shipment_line_id_tab(i)
3629: and transaction_type NOT IN ('ASN','RECEIPT')
3630: and transaction_id <= p_max_txn_id_tab(i);
3631: --}

Line 3640: WSH_INBOUND_TXN_HISTORY_PKG.post_process(

3636: l_max_rcv_txn_id := p_max_rcv_txn_id;
3637: --}
3638: END IF;
3639: --
3640: WSH_INBOUND_TXN_HISTORY_PKG.post_process(
3641: p_shipment_header_id => p_shipment_header_id,
3642: p_max_rcv_txn_id => l_max_rcv_txn_id,
3643: p_action_code => 'MATCHED',
3644: p_txn_type => p_transaction_type,

Line 3651: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_INBOUND_TXN_HISTORY_PKG.post_process is ', l_return_status);

3647: --
3648: -- Debug Statements
3649: --
3650: IF l_debug_on THEN
3651: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_INBOUND_TXN_HISTORY_PKG.post_process is ', l_return_status);
3652: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3653: END IF;
3654: --
3655: wsh_util_core.api_post_call(