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_INTERFACE dependencies on RCV_TRANSACTIONS

Line 948: rcv_transactions rt

944: -- po_headers ph,
945: rcv_supply rs,
946: rcv_shipment_headers rsh,
947: -- rcv_shipment_lines rsl,
948: rcv_transactions rt
949: where rsh.receipt_source_code = 'VENDOR'
950: -- Bug 3444226 The Join with po_headers is unnecessary
951: -- AND ph.po_header_id = header_id
952: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 971: from rcv_transactions rt2

967: -- transfer_lpn_id should match the lpn being putaway.
968: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
969: -- Fix for 1865886. Commented the above and added the following for lpn
970: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
971: from rcv_transactions rt2
972: where rt2.transaction_type <> 'DELIVER'
973: start with rt2.transaction_id = rs.supply_source_id
974: connect by prior rt2.transaction_id = rt2.parent_transaction_id
975: union all

Line 977: from rcv_transactions rt2

973: start with rt2.transaction_id = rs.supply_source_id
974: connect by prior rt2.transaction_id = rt2.parent_transaction_id
975: union all
976: select nvl(rt2.lpn_id,-1)
977: from rcv_transactions rt2
978: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
979: start with rt2.transaction_id = rs.supply_source_id
980: connect by prior rt2.transaction_id = rt2.parent_transaction_id
981: )

Line 1048: rcv_transactions rt

1044: -- po_headers ph,
1045: rcv_supply rs,
1046: rcv_shipment_headers rsh,
1047: -- rcv_shipment_lines rsl,
1048: rcv_transactions rt
1049: where rsh.receipt_source_code = 'VENDOR'
1050: -- Bug 3444226 The Join with po_headers is unnecessary
1051: -- AND ph.po_header_id = header_id
1052: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 1071: from rcv_transactions rt2

1067: -- transfer_lpn_id should match the lpn being putaway.
1068: --AND Nvl(rt.transfer_lpn_id,-1) = Nvl(v_lpn_id,-1)
1069: -- Fix for 1865886. Commented the above and added the following for lpn
1070: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1071: from rcv_transactions rt2
1072: where rt2.transaction_type <> 'DELIVER'
1073: start with rt2.transaction_id = rs.supply_source_id
1074: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1075: union all

Line 1077: from rcv_transactions rt2

1073: start with rt2.transaction_id = rs.supply_source_id
1074: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1075: union all
1076: select nvl(rt2.lpn_id,-1)
1077: from rcv_transactions rt2
1078: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1079: start with rt2.transaction_id = rs.supply_source_id
1080: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1081: )

Line 1156: rcv_transactions rt

1152: po_line_locations pll,
1153: po_lines pl,
1154: rcv_supply rs,
1155: rcv_shipment_headers rsh,
1156: rcv_transactions rt
1157: where rsh.receipt_source_code = 'VENDOR'
1158: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1159: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
1160: AND pod.po_distribution_id = Nvl(v_po_distribution_id, pod.po_distribution_id)

Line 1173: from rcv_transactions rt2

1169: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1170: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1171: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1172: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1173: from rcv_transactions rt2
1174: where rt2.transaction_type <> 'DELIVER'
1175: start with rt2.transaction_id = rs.supply_source_id
1176: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1177: union all

Line 1179: from rcv_transactions rt2

1175: start with rt2.transaction_id = rs.supply_source_id
1176: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1177: union all
1178: select nvl(rt2.lpn_id,-1)
1179: from rcv_transactions rt2
1180: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1181: start with rt2.transaction_id = rs.supply_source_id
1182: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1183: )

Line 1243: rcv_transactions rt

1239: po_line_locations pll,
1240: po_lines pl,
1241: rcv_supply rs,
1242: rcv_shipment_headers rsh,
1243: rcv_transactions rt
1244: where rsh.receipt_source_code = 'VENDOR'
1245: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)
1246: AND pod.line_location_id = Nvl(v_po_line_location_id, pod.line_location_id)
1247: AND pod.po_distribution_id = Nvl(v_po_distribution_id, pod.po_distribution_id)

Line 1260: from rcv_transactions rt2

1256: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1257: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1258: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1259: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)
1260: from rcv_transactions rt2
1261: where rt2.transaction_type <> 'DELIVER'
1262: start with rt2.transaction_id = rs.supply_source_id
1263: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1264: union all

Line 1266: from rcv_transactions rt2

1262: start with rt2.transaction_id = rs.supply_source_id
1263: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1264: union all
1265: select nvl(rt2.lpn_id,-1)
1266: from rcv_transactions rt2
1267: where rt2.transaction_type not in ('RECEIVE', 'DELIVER')
1268: start with rt2.transaction_id = rs.supply_source_id
1269: connect by prior rt2.transaction_id = rt2.parent_transaction_id
1270: )

Line 1320: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;

1316: x_bkp_qty number := 0;
1317: x_progress varchar2(3);
1318: x_converted_trx_qty number := 0;
1319: transaction_ok boolean := FALSE;
1320: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;
1321: high_range_date DATE;
1322: low_range_date DATE;
1323: rows_fetched number := 0;
1324: x_tolerable_qty number := 0;

Line 1389: SAVEPOINT rcv_transactions_sa;

1385: BEGIN
1386:
1387: x_return_status := fnd_api.g_ret_sts_success;
1388:
1389: SAVEPOINT rcv_transactions_sa;
1390:
1391: l_allow_routing_override := fnd_profile.value('OVERRIDE_ROUTING');
1392: IF l_allow_routing_override IS NULL THEN
1393: l_allow_routing_override := 'N';

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

2073: /* Bug 4004656 -Commented the following statement
2074: if (lastrecord or x_remaining_quantity <= 0) then */
2075: /* Bug 4747997: We have to compare the rounded off values by 5 decimal places,
2076: as the value hold by this variable is non-rounded value returned
2077: from the API rcv_transactions_interface_sv.convert_into_correct_qty() */
2078:
2079: if (lastrecord or round(l_rem_qty_trans_uom,5) <= 0) then --Bug 4747997
2080: --End of fix for Bug 4004656
2081: IF l_print_debug = 1 THEN

Line 2197: rcv_transactions_interface_sv.convert_into_correct_qty(

2193: END IF;
2194: temp_cascaded_table(current_n).primary_quantity :=
2195: temp_cascaded_table(current_n).primary_quantity +
2196: /* Bug 4004656
2197: rcv_transactions_interface_sv.convert_into_correct_qty(
2198: x_remaining_quantity,
2199: temp_cascaded_table(1).unit_of_measure,
2200: temp_cascaded_table(1).item_id,
2201: temp_cascaded_table(1).primary_unit_of_measure); */

Line 2202: rcv_transactions_interface_sv.convert_into_correct_qty(

2198: x_remaining_quantity,
2199: temp_cascaded_table(1).unit_of_measure,
2200: temp_cascaded_table(1).item_id,
2201: temp_cascaded_table(1).primary_unit_of_measure); */
2202: rcv_transactions_interface_sv.convert_into_correct_qty(
2203: l_rem_qty_trans_uom,
2204: temp_cascaded_table(1).unit_of_measure,
2205: temp_cascaded_table(1).item_id,
2206: temp_cascaded_table(1).primary_unit_of_measure);

Line 2690: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

2686: Retained it in the transaction uom through the variable l_rcv_qty_trans_uom
2687: by assigning the value of the remaining quantity l_rem_qty_trans_uom
2688: which is already in the transaciton uom */
2689: /* x_remaining_qty_po_uom :=
2690: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
2691: temp_cascaded_table(1).unit_of_measure,
2692: temp_cascaded_table(1).item_id,
2693: x_ShipmentDistributionRec.unit_meas_lookup_code); */
2694:

Line 2762: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_po_uom,

2758:
2759: -- change asn uom qty so both qtys are in sync
2760:
2761: x_remaining_quantity :=
2762: rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_po_uom,
2763: x_ShipmentDistributionRec.unit_meas_lookup_code,
2764: temp_cascaded_table(1).item_id,
2765: temp_cascaded_table(1).unit_of_measure);
2766:

Line 2818: rcv_transactions_interface_sv.convert_into_correct_qty

2814: end if; */
2815: if l_trx_qty_po_uom > 0 then
2816: --Added the following code
2817: l_trx_qty_trans_uom:=
2818: rcv_transactions_interface_sv.convert_into_correct_qty
2819: (l_trx_qty_po_uom,
2820: x_ShipmentDistributionRec.unit_meas_lookup_code,
2821: temp_cascaded_table(1).item_id,
2822: temp_cascaded_table(1).unit_of_measure);

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

2830:
2831: if (round(l_trx_qty_trans_uom,5) < round(l_rcv_qty_trans_uom,5)) then --Bug 4747997
2832: -- compare like uoms which is the transaction uom
2833: l_rcv_qty_trans_uom := l_rcv_qty_trans_uom - l_trx_qty_trans_uom;
2834: l_rcv_qty_po_uom:= rcv_transactions_interface_sv.convert_into_correct_qty(l_rcv_qty_trans_uom,
2835: temp_cascaded_table(1).unit_of_measure,
2836: temp_cascaded_table(1).item_id,
2837: x_ShipmentDistributionRec.unit_meas_lookup_code);
2838:

Line 2915: rcv_transactions_interface_sv.convert_into_correct_qty(

2911: -- quantity,quantity_shipped -> in ASN uom
2912:
2913: temp_cascaded_table(current_n).source_doc_quantity :=
2914: -- x_converted_trx_qty; -- in po uom --Bug 4004656
2915: rcv_transactions_interface_sv.convert_into_correct_qty(
2916: l_trx_qty_trans_uom ,
2917: temp_cascaded_table(current_n).unit_of_measure,
2918: temp_cascaded_table(current_n).item_id,
2919: x_ShipmentDistributionRec.unit_meas_lookup_code);

Line 2927: rcv_transactions_interface_sv.convert_into_correct_qty(

2923: x_ShipmentDistributionRec.unit_meas_lookup_code;
2924:
2925: temp_cascaded_table(current_n).quantity :=
2926: /* Bug 4004656
2927: rcv_transactions_interface_sv.convert_into_correct_qty(
2928: x_converted_trx_qty,
2929: x_ShipmentDistributionRec.unit_meas_lookup_code,
2930: temp_cascaded_table(current_n).item_id,
2931: temp_cascaded_table(current_n).unit_of_measure); -- in asn uom */

Line 2945: rcv_transactions_interface_sv.convert_into_correct_qty(

2941: x_ShipmentDistributionRec.unit_meas_lookup_code;
2942: END IF;
2943: temp_cascaded_table(current_n).primary_quantity :=
2944: /* Bug 4004656
2945: rcv_transactions_interface_sv.convert_into_correct_qty(
2946: x_converted_trx_qty,
2947: x_ShipmentDistributionRec.unit_meas_lookup_code,
2948: temp_cascaded_table(current_n).item_id,
2949: temp_cascaded_table(current_n).primary_unit_of_measure); */

Line 2951: rcv_transactions_interface_sv.convert_into_correct_qty(

2947: x_ShipmentDistributionRec.unit_meas_lookup_code,
2948: temp_cascaded_table(current_n).item_id,
2949: temp_cascaded_table(current_n).primary_unit_of_measure); */
2950:
2951: rcv_transactions_interface_sv.convert_into_correct_qty(
2952: l_trx_qty_trans_uom,
2953: temp_cascaded_table(current_n).unit_of_measure,
2954: temp_cascaded_table(current_n).item_id,
2955: temp_cascaded_table(current_n).primary_unit_of_measure);

Line 3139: ROLLBACK TO rcv_transactions_sa;

3135: --4364407
3136:
3137: exception
3138: WHEN fnd_api.g_exc_error THEN
3139: ROLLBACK TO rcv_transactions_sa;
3140: x_return_status := fnd_api.g_ret_sts_error;
3141: -- Get message count and data
3142: fnd_msg_pub.count_and_get
3143: ( p_count => x_msg_count

Line 3214: ROLLBACK TO rcv_transactions_sa;

3210: END IF;
3211: --4364407
3212:
3213: WHEN fnd_api.g_exc_unexpected_error THEN
3214: ROLLBACK TO rcv_transactions_sa;
3215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3216:
3217: -- Get message count and data
3218: fnd_msg_pub.count_and_get

Line 3291: ROLLBACK TO rcv_transactions_sa;

3287: END IF;
3288: --4364407
3289:
3290: WHEN OTHERS THEN
3291: ROLLBACK TO rcv_transactions_sa;
3292: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3293: IF SQLCODE IS NOT NULL THEN
3294: inv_mobile_helper_functions.sql_error('INV_RCV_TXN_INTERFACE.matching_logic', l_progress, SQLCODE);
3295: END IF;