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.INV_RCV_TXN_MATCH dependencies on RCV_TRANSACTIONS

Line 1258: , rcv_transactions rt

1254: , To_number(NULL) po_distribution_id
1255: , rsl.item_description item_description
1256: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
1257: FROM rcv_supply rsup
1258: , rcv_transactions rt
1259: , rcv_shipment_headers rsh
1260: , rcv_shipment_lines rsl
1261: WHERE rsl.shipment_header_id = v_shipment_header_id
1262: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 1281: from rcv_transactions rt2

1277: -- transfer_lpn_id should match the lpn being putaway.
1278: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1279: -- Fix for 1865886. Commented the above and added the following for lpn
1280: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1281: from rcv_transactions rt2
1282: where rt2.transaction_type <> 'DELIVER'
1283: start with rt2.transaction_id = rsup.supply_source_id
1284: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1285: union all

Line 1287: from rcv_transactions rt2

1283: start with rt2.transaction_id = rsup.supply_source_id
1284: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1285: union all
1286: select nvl(rt2.lpn_id,-1)
1287: from rcv_transactions rt2
1288: /* Changes made for bug #4926987 -- added ACCEPT and REJECT */
1289: where rt2.transaction_type not in ('RECEIVE', 'DELIVER','ACCEPT','REJECT')
1290: /* End of changes made for bug #4926987 -- added ACCEPT and REJECT */
1291: start with rt2.transaction_id = rsup.supply_source_id

Line 1339: , rcv_transactions rt

1335: ,v_parent_txn_id_to_match NUMBER)
1336: IS
1337: SELECT COUNT(*)
1338: FROM rcv_supply rsup
1339: , rcv_transactions rt
1340: , rcv_shipment_headers rsh
1341: , rcv_shipment_lines rsl
1342: WHERE rsl.shipment_header_id = v_shipment_header_id
1343: AND rsl.shipment_line_id = Nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 1362: from rcv_transactions rt2

1358: -- transfer_lpn_id should match the lpn being putaway.
1359: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1360: -- Fix for 1865886. Commented the above and added the following for lpn
1361: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1362: from rcv_transactions rt2
1363: where rt2.transaction_type <> 'DELIVER'
1364: start with rt2.transaction_id = rsup.supply_source_id
1365: connect by prior transaction_id = parent_transaction_id
1366: union all

Line 1368: from rcv_transactions

1364: start with rt2.transaction_id = rsup.supply_source_id
1365: connect by prior transaction_id = parent_transaction_id
1366: union all
1367: select nvl(lpn_id,-1)
1368: from rcv_transactions
1369: /* Changes made for bug #4926987 -- added ACCEPT and REJECT */
1370: where transaction_type not in ('RECEIVE', 'DELIVER', 'ACCEPT', 'REJECT')
1371: /* End Changes made for bug #4926987 -- added ACCEPT and REJECT */
1372: start with transaction_id = rsup.supply_source_id

Line 1442: , rcv_transactions rt

1438: , To_number(NULL)
1439: , To_char(NULL)
1440: , To_char(NULL)
1441: FROM rcv_supply rsup
1442: , rcv_transactions rt
1443: , rcv_shipment_headers rsh
1444: WHERE rsh.receipt_source_code = 'CUSTOMER'
1445: AND rsup.item_id = v_item_id
1446: AND rsup.oe_order_header_id = v_oe_order_header_id

Line 1464: from rcv_transactions rt2

1460: -- transfer_lpn_id should match the lpn being putaway.
1461: -- AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1462: -- Fix for 1865886. Commented the above and added the following for lpn
1463: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1464: from rcv_transactions rt2
1465: where rt2.transaction_type <> 'DELIVER'
1466: start with rt2.transaction_id = rsup.supply_source_id
1467: connect by prior transaction_id = parent_transaction_id
1468: union all

Line 1470: from rcv_transactions

1466: start with rt2.transaction_id = rsup.supply_source_id
1467: connect by prior transaction_id = parent_transaction_id
1468: union all
1469: select nvl(lpn_id,-1)
1470: from rcv_transactions
1471: where transaction_type not in ('RECEIVE', 'DELIVER')
1472: start with transaction_id = rsup.supply_source_id
1473: connect by prior transaction_id = parent_transaction_id
1474: )

Line 1511: , rcv_transactions rt

1507: ,v_parent_txn_id_to_match NUMBER)
1508: IS
1509: SELECT COUNT(*)
1510: FROM rcv_supply rsup
1511: , rcv_transactions rt
1512: , rcv_shipment_headers rsh
1513: WHERE rsh.receipt_source_code = 'CUSTOMER'
1514: AND rsup.item_id = v_item_id
1515: AND rsup.oe_order_header_id = v_oe_order_header_id

Line 1533: from rcv_transactions rt2

1529: -- transfer_lpn_id should match the lpn being putaway.
1530: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1531: -- Fix for 1865886. Commented the above and added the following for lpn
1532: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1533: from rcv_transactions rt2
1534: where rt2.transaction_type <> 'DELIVER'
1535: start with rt2.transaction_id = rsup.supply_source_id
1536: connect by prior transaction_id = parent_transaction_id
1537: union all

Line 1539: from rcv_transactions

1535: start with rt2.transaction_id = rsup.supply_source_id
1536: connect by prior transaction_id = parent_transaction_id
1537: union all
1538: select nvl(lpn_id,-1)
1539: from rcv_transactions
1540: where transaction_type not in ('RECEIVE', 'DELIVER')
1541: start with transaction_id = rsup.supply_source_id
1542: connect by prior transaction_id = parent_transaction_id
1543: )

Line 1595: , rcv_transactions rt

1591: , pod.po_distribution_id po_distribution_id
1592: , rsl.item_description item_description
1593: , to_char(null)
1594: FROM rcv_supply rsup
1595: , rcv_transactions rt
1596: , rcv_shipment_headers rsh
1597: , rcv_shipment_lines rsl
1598: , po_line_locations poll
1599: , po_distributions pod

Line 1629: from rcv_transactions rt2

1625: -- transfer_lpn_id should match the lpn being putaway.
1626: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1627: -- Fix for 1865886. Commented the above and added the following for lpn
1628: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1629: from rcv_transactions rt2
1630: where rt2.transaction_type <> 'DELIVER'
1631: start with rt2.transaction_id = rsup.supply_source_id
1632: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1633: union all

Line 1635: from rcv_transactions rt2

1631: start with rt2.transaction_id = rsup.supply_source_id
1632: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1633: union all
1634: select nvl(rt2.lpn_id,-1)
1635: from rcv_transactions rt2
1636: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1637: start with rt2.transaction_id = rsup.supply_source_id
1638: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1639: )

Line 1676: , rcv_transactions rt

1672:
1673: IS
1674: SELECT COUNT(*)
1675: FROM rcv_supply rsup
1676: , rcv_transactions rt
1677: , rcv_shipment_headers rsh
1678: , rcv_shipment_lines rsl
1679: , po_line_locations poll
1680: , po_distributions pod

Line 1710: from rcv_transactions rt2

1706: -- transfer_lpn_id should match the lpn being putaway.
1707: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1708: -- Fix for 1865886. Commented the above and added the following for lpn
1709: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1710: from rcv_transactions rt2
1711: where rt2.transaction_type <> 'DELIVER'
1712: start with rt2.transaction_id = rsup.supply_source_id
1713: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1714: union all

Line 1716: from rcv_transactions rt2

1712: start with rt2.transaction_id = rsup.supply_source_id
1713: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1714: union all
1715: select nvl(rt2.lpn_id,-1)
1716: from rcv_transactions rt2
1717: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1718: start with rt2.transaction_id = rsup.supply_source_id
1719: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1720: )

Line 1770: , rcv_transactions rt

1766: , pod.po_distribution_id po_distribution_id
1767: , rsl.item_description item_description
1768: , to_char(null)
1769: FROM rcv_supply rsup
1770: , rcv_transactions rt
1771: , rcv_shipment_headers rsh
1772: , rcv_shipment_lines rsl
1773: , po_line_locations poll
1774: , po_distributions pod

Line 1804: from rcv_transactions rt2

1800: -- transfer_lpn_id should match the lpn being putaway.
1801: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1802: -- Fix for 1865886. Commented the above and added the following for lpn
1803: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1804: from rcv_transactions rt2
1805: where rt2.transaction_type <> 'DELIVER'
1806: start with rt2.transaction_id = rsup.supply_source_id
1807: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1808: union all

Line 1810: from rcv_transactions rt2

1806: start with rt2.transaction_id = rsup.supply_source_id
1807: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1808: union all
1809: select nvl(rt2.lpn_id,-1)
1810: from rcv_transactions rt2
1811: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1812: start with rt2.transaction_id = rsup.supply_source_id
1813: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1814: )

Line 1847: , rcv_transactions rt

1843: ,v_lpn_id_to_match NUMBER)
1844: IS
1845: SELECT COUNT(*)
1846: FROM rcv_supply rsup
1847: , rcv_transactions rt
1848: , rcv_shipment_headers rsh
1849: , rcv_shipment_lines rsl
1850: , po_line_locations poll
1851: , po_distributions pod

Line 1881: from rcv_transactions rt2

1877: -- transfer_lpn_id should match the lpn being putaway.
1878: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1879: -- Fix for 1865886. Commented the above and added the following for lpn
1880: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1881: from rcv_transactions rt2
1882: where rt2.transaction_type <> 'DELIVER'
1883: start with rt2.transaction_id = rsup.supply_source_id
1884: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1885: union all

Line 1887: from rcv_transactions rt2

1883: start with rt2.transaction_id = rsup.supply_source_id
1884: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1885: union all
1886: select nvl(rt2.lpn_id,-1)
1887: from rcv_transactions rt2
1888: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1889: start with rt2.transaction_id = rsup.supply_source_id
1890: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1891: )

Line 1920: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;

1916: x_bkp_qty NUMBER := 0;
1917: x_progress VARCHAR2(3);
1918: x_converted_trx_qty NUMBER := 0;
1919: transaction_ok BOOLEAN := FALSE;
1920: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;
1921: high_range_date DATE;
1922: low_range_date DATE;
1923: rows_fetched NUMBER := 0;
1924: x_tolerable_qty NUMBER := 0;

Line 2015: SAVEPOINT rcv_transactions_gen_sa;

2011: END IF;
2012:
2013: x_return_status := fnd_api.g_ret_sts_success;
2014:
2015: SAVEPOINT rcv_transactions_gen_sa;
2016:
2017: -- storing the passed value to match with the parent_txn_id in a local
2018: -- var and nulling out the variable in the record to simulate the
2019: -- behavior as was prior to patchset J changes.

Line 2720: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */

2716: /* Bug 4004656 -Commented the following statement
2717: IF (lastrecord OR x_remaining_quantity <= 0) THEN */
2718: /* Bug 4747997: We have to compare the rounded off values by 5 decimal places,
2719: as the value hold by this variable is non-rounded value returned
2720: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */
2721: IF (lastrecord OR round(l_rem_qty_trans_uom,5) <=0) THEN --Bug 4004656, Bug:4747997
2722: IF (l_debug = 1) THEN
2723: print_debug('No more rows or the remaining qty is less than zero',4);
2724: END IF;

Line 2889: l_rcv_tolerance_qty_txn_uom := rcv_transactions_interface_sv.convert_into_correct_qty(

2885: is getting calculated in RMA uom instead of transaction uom.
2886: So, We need to convert the tolerance qty for RMA to transaction uom. */
2887: l_rcv_tolerance_qty_rma_uom := x_oe_line_qty * (x_qty_rcv_tolerance/100);
2888:
2889: l_rcv_tolerance_qty_txn_uom := rcv_transactions_interface_sv.convert_into_correct_qty(
2890: l_rcv_tolerance_qty_rma_uom,
2891: x_MatchedRec.unit_of_measure,
2892: temp_cascaded_table(1).item_id,
2893: temp_cascaded_table(1).unit_of_measure);

Line 3392: rcv_transactions_interface_sv.convert_into_correct_qty

3388: Retained it in the transaction uom through the variable l_rcv_qty_trans_uom
3389: by assigning the value of the remaining quantity l_rem_qty_trans_uom
3390: which is already in the transaciton uom */
3391: /* x_remaining_qty_po_uom :=
3392: rcv_transactions_interface_sv.convert_into_correct_qty
3393: (x_remaining_quantity,
3394: temp_cascaded_table(1).unit_of_measure,
3395: temp_cascaded_table(1).item_id,
3396: x_MatchedRec.unit_of_measure); */

Line 3424: rcv_transactions_interface_sv.convert_into_correct_qty

3420: x_converted_trx_qty;
3421:
3422: -- change asn uom qty so both qtys are in sync
3423: x_remaining_quantity :=
3424: rcv_transactions_interface_sv.convert_into_correct_qty
3425: (x_remaining_qty_po_uom,
3426: x_MatchedRec.unit_of_measure,
3427: temp_cascaded_table(1).item_id,
3428: temp_cascaded_table(1).unit_of_measure);

Line 3476: rcv_transactions_interface_sv.convert_into_correct_qty

3472: IF round(l_rcv_qty_trans_uom,5) <> 0 THEN --Bug 4747997
3473: if l_trx_qty_po_uom > 0 then
3474: --Added the following code
3475: l_trx_qty_trans_uom:=
3476: rcv_transactions_interface_sv.convert_into_correct_qty
3477: (l_trx_qty_po_uom,
3478: x_MatchedRec.unit_of_measure,
3479: temp_cascaded_table(1).item_id,
3480: temp_cascaded_table(1).unit_of_measure);

Line 3493: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,

3489:
3490: IF ((round(l_rcv_qty_trans_uom,5) - round(l_trx_qty_trans_uom,5)) > 0.00005) THEN --Bug: 4747997 /BUG13591755
3491: -- compare like uoms which is the transaction uom
3492: l_rcv_qty_trans_uom := l_rcv_qty_trans_uom - l_trx_qty_trans_uom;
3493: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,
3494: temp_cascaded_table(1).unit_of_measure,
3495: temp_cascaded_table(1).item_id,
3496: x_MatchedRec.unit_of_measure);
3497:

Line 3555: rcv_transactions_interface_sv.convert_into_correct_qty(

3551: END IF;
3552:
3553: temp_cascaded_table(current_n).source_doc_quantity :=
3554: -- x_converted_trx_qty; -- in po uom --Bug 4004656
3555: rcv_transactions_interface_sv.convert_into_correct_qty(
3556: l_trx_qty_trans_uom ,
3557: temp_cascaded_table(current_n).unit_of_measure,
3558: temp_cascaded_table(current_n).item_id,
3559: x_MatchedRec.unit_of_measure);

Line 3572: rcv_transactions_interface_sv.convert_into_correct_qty

3568: END IF;
3569:
3570: temp_cascaded_table(current_n).quantity :=
3571: /* Bug 4004656
3572: rcv_transactions_interface_sv.convert_into_correct_qty
3573: (x_converted_trx_qty,
3574: x_MatchedRec.unit_of_measure,
3575: temp_cascaded_table(current_n).item_id,
3576: temp_cascaded_table(current_n).unit_of_measure); -- in asn uom */

Line 3586: rcv_transactions_interface_sv.convert_into_correct_qty

3582:
3583: -- Primary qty in Primary UOM
3584: temp_cascaded_table(current_n).primary_quantity :=
3585: /* Bug 4004656
3586: rcv_transactions_interface_sv.convert_into_correct_qty
3587: (x_converted_trx_qty,
3588: x_MatchedRec.unit_of_measure,
3589: temp_cascaded_table(current_n).item_id,
3590: temp_cascaded_table(current_n).primary_unit_of_measure); */

Line 3592: rcv_transactions_interface_sv.convert_into_correct_qty(

3588: x_MatchedRec.unit_of_measure,
3589: temp_cascaded_table(current_n).item_id,
3590: temp_cascaded_table(current_n).primary_unit_of_measure); */
3591:
3592: rcv_transactions_interface_sv.convert_into_correct_qty(
3593: l_trx_qty_trans_uom,
3594: temp_cascaded_table(current_n).unit_of_measure,
3595: temp_cascaded_table(current_n).item_id,
3596: temp_cascaded_table(current_n).primary_unit_of_measure);

Line 3735: ROLLBACK TO rcv_transactions_gen_sa;

3731:
3732:
3733: EXCEPTION
3734: WHEN fnd_api.g_exc_error THEN
3735: ROLLBACK TO rcv_transactions_gen_sa;
3736: x_return_status := fnd_api.g_ret_sts_error;
3737:
3738: -- Get message count and data
3739: fnd_msg_pub.count_and_get

Line 3819: ROLLBACK TO rcv_transactions_gen_sa;

3815: CLOSE count_int_req_delivery_lines;
3816: END IF;
3817:
3818: WHEN fnd_api.g_exc_unexpected_error THEN
3819: ROLLBACK TO rcv_transactions_gen_sa;
3820: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3821:
3822: -- Get message count and data
3823: fnd_msg_pub.count_and_get

Line 3891: ROLLBACK TO rcv_transactions_gen_sa;

3887: CLOSE rma_delivery_lines;
3888: END IF;
3889:
3890: WHEN OTHERS THEN
3891: ROLLBACK TO rcv_transactions_gen_sa;
3892: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3893:
3894: IF SQLCODE IS NOT NULL THEN
3895: inv_mobile_helper_functions.sql_error('inv_rcv_txn_match.matching_logic', l_progress, SQLCODE);