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_RMA_TRANSACTIONS dependencies on MTL_SYSTEM_ITEMS

Line 27: mtl_system_items msi

23: oel.subinventory subinventory,
24: oel.ship_from_org_id deliver_to_location_id
25: FROM oe_order_headers oeh,
26: oe_order_lines oel,
27: mtl_system_items msi
28: WHERE oel.line_id = v_line_id
29: AND oel.header_id = oeh.header_id
30: AND oel.booked_flag = 'Y'
31: AND oel.ordered_quantity > NVL(oel.shipped_quantity, 0)

Line 587: FROM mtl_system_items

583: --NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
584: INTO x_cascaded_table(n).primary_unit_of_measure
585: --x_cascaded_table(n).use_mtl_lot,
586: --x_cascaded_table(n).use_mtl_serial
587: FROM mtl_system_items
588: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
589: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
590:
591: IF (g_asn_debug = 'Y') THEN

Line 588: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id

584: INTO x_cascaded_table(n).primary_unit_of_measure
585: --x_cascaded_table(n).use_mtl_lot,
586: --x_cascaded_table(n).use_mtl_serial
587: FROM mtl_system_items
588: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
589: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
590:
591: IF (g_asn_debug = 'Y') THEN
592: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);

Line 589: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

585: --x_cascaded_table(n).use_mtl_lot,
586: --x_cascaded_table(n).use_mtl_serial
587: FROM mtl_system_items
588: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
589: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
590:
591: IF (g_asn_debug = 'Y') THEN
592: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);
593: END IF;

Line 1062: mtl_system_items msi

1058: oe_order_lines_all oel,
1059: oe_transaction_types_all olt,
1060: oe_transaction_types_tl t,
1061: mtl_units_of_measure_tl mum,
1062: mtl_system_items msi
1063: WHERE oeh.header_id = v_header_id
1064: AND oeh.header_id = oel.header_id
1065: AND oel.line_id = NVL(v_line_id, oel.line_id)-- bug 4740567
1066: AND oel.line_number = NVL(v_rma_line_num, oel.line_number)

Line 2761: x_inventory_item mtl_system_items.inventory_item_id%TYPE;

2757: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
2758: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2759: ) IS -- bug 608353
2760: x_progress VARCHAR2(3);
2761: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2762: x_organization_id mtl_system_items.organization_id%TYPE;
2763: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2764: x_error_status VARCHAR2(1);
2765: BEGIN

Line 2762: x_organization_id mtl_system_items.organization_id%TYPE;

2758: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2759: ) IS -- bug 608353
2760: x_progress VARCHAR2(3);
2761: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2762: x_organization_id mtl_system_items.organization_id%TYPE;
2763: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2764: x_error_status VARCHAR2(1);
2765: BEGIN
2766: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 2771: FROM mtl_system_items

2767: x_progress := '000';
2768:
2769: SELECT NVL(MAX(inventory_item_id), -9999)
2770: INTO x_inventory_item
2771: FROM mtl_system_items
2772: WHERE inventory_item_id = x_item_id_record.item_id;
2773:
2774: IF (x_inventory_item = -9999) THEN
2775: rcv_error_pkg.set_error_message('RCV_ITEM_ID');

Line 2781: FROM mtl_system_items

2777: END IF;
2778:
2779: SELECT NVL(MAX(inventory_item_id), -9999)
2780: INTO x_inventory_item
2781: FROM mtl_system_items
2782: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
2783: AND inventory_item_id = x_item_id_record.item_id;
2784:
2785: IF (x_inventory_item = -9999) THEN

Line 2800: FROM mtl_system_items

2796: * check for nvl(max(item_id),0).
2797: */
2798: SELECT NVL(MAX(organization_id), -9999)
2799: INTO x_organization_id
2800: FROM mtl_system_items
2801: WHERE inventory_item_id = x_item_id_record.item_id
2802: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
2803:
2804: IF (x_organization_id = -9999) THEN

Line 2885: x_inventory_item mtl_system_items.inventory_item_id%TYPE;

2881: ===========================================================================*/
2882: PROCEDURE validate_item_revision(
2883: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
2884: ) IS
2885: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2886: x_progress VARCHAR2(3);
2887: x_revision_control_flag VARCHAR2(1);
2888: x_error_status VARCHAR2(1);
2889: BEGIN

Line 2901: FROM mtl_system_items msi

2897: 2, 'Y',
2898: 'N'
2899: )
2900: INTO x_revision_control_flag
2901: FROM mtl_system_items msi
2902: WHERE inventory_item_id = x_item_revision_record.item_id
2903: AND organization_id = x_item_revision_record.to_organization_id;
2904:
2905: IF x_revision_control_flag = 'N' THEN

Line 3047: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;

3043: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
3044: x_unit_meas_lookup_code_lines po_lines_all.unit_meas_lookup_code%TYPE := NULL;
3045: x_progress VARCHAR2(3);
3046: x_new_conversion NUMBER := 0;
3047: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
3048: x_error_status VARCHAR2(1);
3049: BEGIN
3050: x_error_status := rcv_error_pkg.g_ret_sts_error;
3051: x_progress := '000';

Line 3076: FROM mtl_system_items_kfv

3072: -- must have a primary uom at this point since the first select stmt succeeded
3073:
3074: SELECT primary_unit_of_measure
3075: INTO x_primary_unit_of_measure
3076: FROM mtl_system_items_kfv
3077: WHERE inventory_item_id = x_uom_record.item_id
3078: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
3079:
3080: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN

Line 3162: FROM mtl_system_items msi

3158: 2, 'Y',
3159: 'N'
3160: )
3161: INTO x_revision_control_flag
3162: FROM mtl_system_items msi
3163: WHERE inventory_item_id = x_item_revision_record.item_id
3164: AND organization_id = x_item_revision_record.to_organization_id;
3165:
3166: /* If item is under revision control