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

Line 199: rcv_transactions_interface_sv.get_reason_id(reason_id_record);

195: IF (g_asn_debug = 'Y') THEN
196: asn_debug.put_line('Derive Reason_id');
197: END IF;
198:
199: rcv_transactions_interface_sv.get_reason_id(reason_id_record);
200: x_cascaded_table(n).reason_id := reason_id_record.reason_id;
201: x_cascaded_table(n).error_status := reason_id_record.error_record.error_status;
202: x_cascaded_table(n).error_message := reason_id_record.error_record.error_message;
203: END IF;

Line 335: FROM rcv_transactions rt,

331: rt.primary_unit_of_measure,
332: rt.quantity,
333: rt.transaction_id,
334: rt.unit_of_measure
335: FROM rcv_transactions rt,
336: rcv_shipment_lines rsl
337: WHERE transaction_id = v_parent_trx_id
338: AND rt.shipment_line_id = rsl.shipment_line_id;
339:

Line 353: FROM rcv_transactions_interface rti

349: rti.primary_unit_of_measure,
350: rti.quantity,
351: rti.interface_transaction_id transaction_id,
352: rti.unit_of_measure
353: FROM rcv_transactions_interface rti
354: WHERE interface_transaction_id = v_parent_interface_txn_id;
355:
356: x_derive_returnrec derive_return%ROWTYPE;
357: x_temp_parent_trx_qty NUMBER := 0;

Line 363: l_transaction_type rcv_transactions.transaction_type%TYPE;

359: x_temp_convert_parent_trx_qty NUMBER := 0;
360: x_remaining_qty_parent_uom NUMBER := 0;
361: l_to_organization_id NUMBER := 0;
362: l_supply_type_code rcv_supply.supply_type_code%TYPE;
363: l_transaction_type rcv_transactions.transaction_type%TYPE;
364: x_temp_already_allocated_qty NUMBER := 0;
365: derive_values_from_table BOOLEAN := FALSE;
366: derive_values_from_rti BOOLEAN := FALSE;
367: already_derived BOOLEAN := FALSE;

Line 369: l_parent_transaction_type rcv_transactions.transaction_type%TYPE;

365: derive_values_from_table BOOLEAN := FALSE;
366: derive_values_from_rti BOOLEAN := FALSE;
367: already_derived BOOLEAN := FALSE;
368: cascaded_table_index NUMBER;
369: l_parent_transaction_type rcv_transactions.transaction_type%TYPE;
370: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;
371: temp_index NUMBER;
372: l_po_header_id po_headers_all.po_header_id%type;
373: l_return_status VARCHAR2(1) :='S';

Line 370: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;

366: derive_values_from_rti BOOLEAN := FALSE;
367: already_derived BOOLEAN := FALSE;
368: cascaded_table_index NUMBER;
369: l_parent_transaction_type rcv_transactions.transaction_type%TYPE;
370: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;
371: temp_index NUMBER;
372: l_po_header_id po_headers_all.po_header_id%type;
373: l_return_status VARCHAR2(1) :='S';
374: l_complex_flag varchar2(1);

Line 427: /* 2119137 : If the user populates rcv_transactions_interface

423: -- the asn is consumed. (Cascade)
424: -- For return, there will be no cascade since there's only 1 parent txn per
425: -- return, the temp_cascade_table will be deprecated in phase 2 -pjiang
426:
427: /* 2119137 : If the user populates rcv_transactions_interface
428: with po_line_id, then ROI errors out with
429: RCV_ASN_NO_PO_LINE_LOCATION_ID when the document_line_num
430: is not provided for one time items. Modified the "if" criteria in
431: such a way that the ROI validation does'nt error out when

Line 656: x_remaining_qty_parent_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

652: END IF; /* if already_allocated_qty is >0 for return */ --}
653: END IF; /*derive_values_from_rti is false */--}
654: END IF; --} interface_available_qty is 0.
655:
656: x_remaining_qty_parent_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
657: temp_cascaded_table(1).unit_of_measure,
658: temp_cascaded_table(1).item_id,
659: x_derive_returnrec.unit_of_measure
660: );

Line 685: x_remaining_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_parent_uom,

681: */
682: x_remaining_qty_parent_uom := x_remaining_qty_parent_uom - x_converted_parent_trx_qty;
683:
684: IF (temp_cascaded_table(current_n).unit_of_measure <> x_derive_returnrec.unit_of_measure) THEN
685: x_remaining_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_qty_parent_uom,
686: x_derive_returnrec.unit_of_measure,
687: temp_cascaded_table(1).item_id,
688: temp_cascaded_table(1).unit_of_measure
689: );

Line 756: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_parent_trx_qty,

752: temp_cascaded_table(current_n).primary_unit_of_measure := x_derive_returnrec.primary_unit_of_measure;
753: temp_cascaded_table(current_n).quantity := x_converted_parent_trx_qty;
754:
755: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_derive_returnrec.unit_of_measure) THEN
756: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_parent_trx_qty,
757: x_derive_returnrec.unit_of_measure,
758: temp_cascaded_table(current_n).item_id,
759: temp_cascaded_table(current_n).primary_unit_of_measure
760: );

Line 1223: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,

1219: * the parameters here so that this can be called from the client side
1220: * library for the Enter returns and Enter corrections forms also.
1221: */
1222: PROCEDURE derive_inv_qty_1(
1223: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,

Line 1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,

1220: * library for the Enter returns and Enter corrections forms also.
1221: */
1222: PROCEDURE derive_inv_qty_1(
1223: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,

Line 1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,

1221: */
1222: PROCEDURE derive_inv_qty_1(
1223: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,

Line 1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,

1222: PROCEDURE derive_inv_qty_1(
1223: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,

Line 1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,

1223: p_destination_type_code IN rcv_transactions_interface.destination_type_code%TYPE,
1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,

Line 1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,

1224: p_transaction_type IN rcv_transactions_interface.transaction_type%TYPE,
1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,

Line 1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,

1225: p_quantity IN rcv_transactions_interface.quantity%TYPE,
1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,

Line 1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,

1226: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%TYPE,
1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,

Line 1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,

1227: p_to_organization_id IN rcv_transactions_interface.to_organization_id%TYPE,
1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,

Line 1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,

1228: p_item_id IN rcv_transactions_interface.item_id%TYPE,
1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,

Line 1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,

1229: p_item_revision IN rcv_transactions_interface.item_revision%TYPE,
1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1237: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,

Line 1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,

1230: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%TYPE,
1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1237: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1238: x_error_status IN OUT NOCOPY VARCHAR2,

Line 1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,

1231: p_po_header_id IN rcv_transactions_interface.po_header_id%TYPE,
1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1237: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1238: x_error_status IN OUT NOCOPY VARCHAR2,
1239: x_error_message IN OUT NOCOPY VARCHAR2

Line 1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,

1232: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%TYPE,
1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1237: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1238: x_error_status IN OUT NOCOPY VARCHAR2,
1239: x_error_message IN OUT NOCOPY VARCHAR2
1240: ) IS

Line 1237: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,

1233: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%TYPE,
1234: p_subinventory IN rcv_transactions_interface.subinventory%TYPE,
1235: p_locator_id IN rcv_transactions_interface.locator_id%TYPE,
1236: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%TYPE,
1237: p_lpn_id IN rcv_transactions_interface.lpn_id%TYPE,
1238: x_error_status IN OUT NOCOPY VARCHAR2,
1239: x_error_message IN OUT NOCOPY VARCHAR2
1240: ) IS
1241: CURSOR lot_rows(

Line 1255: FROM rcv_transactions_interface

1251: CURSOR rti_rows(
1252: l_interface_id NUMBER
1253: ) IS
1254: SELECT quantity
1255: FROM rcv_transactions_interface
1256: WHERE interface_transaction_id = l_interface_id;
1257:
1258: l_rti rti_rows%ROWTYPE;
1259: l_negative_inv_receipt_code NUMBER;

Line 1281: l_revision rcv_transactions_interface.item_revision%TYPE;

1277: l_atr NUMBER;
1278: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1279: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1280: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1281: l_revision rcv_transactions_interface.item_revision%TYPE;
1282: l_primary_qty NUMBER;
1283: l_table_name po_interface_errors.table_name%TYPE;
1284: BEGIN
1285: /* We need to do this only for returns and -ve corrections.

Line 1370: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_lot.transaction_quantity,

1366: asn_debug.put_line('lot_number ' || l_lot.lot_number);
1367: END IF;
1368:
1369: l_lot_number := l_lot.lot_number;
1370: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_lot.transaction_quantity,
1371: p_unit_of_measure,
1372: p_item_id,
1373: p_primary_unit_of_measure
1374: ));

Line 1379: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_rti.quantity,

1375: ELSIF(rti_rows%ISOPEN) THEN --}{
1376: FETCH rti_rows INTO l_rti;
1377: EXIT WHEN rti_rows%NOTFOUND;
1378: l_lot_number := NULL;
1379: l_primary_qty := ABS(rcv_transactions_interface_sv.convert_into_correct_qty(l_rti.quantity,
1380: p_unit_of_measure,
1381: p_item_id,
1382: p_primary_unit_of_measure
1383: ));

Line 1422: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';

1418:
1419: IF (lot_rows%ISOPEN) THEN
1420: l_table_name := 'MTL_TRANSACTION_LOTS_INTERFACE';
1421: ELSE
1422: l_table_name := 'RCV_TRANSACTIONS_INTERFACE';
1423: END IF;
1424:
1425: IF (l_return_status = 'S') THEN --{
1426: x_error_status := 'S';