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 588: FROM mtl_system_items

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

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

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

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

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

Line 1063: mtl_system_items msi

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

Line 2900: x_inventory_item mtl_system_items.inventory_item_id%TYPE;

2896: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
2897: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2898: ) IS -- bug 608353
2899: x_progress VARCHAR2(3);
2900: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2901: x_organization_id mtl_system_items.organization_id%TYPE;
2902: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2903: x_error_status VARCHAR2(1);
2904: BEGIN

Line 2901: x_organization_id mtl_system_items.organization_id%TYPE;

2897: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2898: ) IS -- bug 608353
2899: x_progress VARCHAR2(3);
2900: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2901: x_organization_id mtl_system_items.organization_id%TYPE;
2902: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2903: x_error_status VARCHAR2(1);
2904: BEGIN
2905: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 2910: FROM mtl_system_items

2906: x_progress := '000';
2907:
2908: SELECT NVL(MAX(inventory_item_id), -9999)
2909: INTO x_inventory_item
2910: FROM mtl_system_items
2911: WHERE inventory_item_id = x_item_id_record.item_id;
2912:
2913: IF (x_inventory_item = -9999) THEN
2914: rcv_error_pkg.set_error_message('RCV_ITEM_ID');

Line 2920: FROM mtl_system_items

2916: END IF;
2917:
2918: SELECT NVL(MAX(inventory_item_id), -9999)
2919: INTO x_inventory_item
2920: FROM mtl_system_items
2921: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
2922: AND inventory_item_id = x_item_id_record.item_id
2923: AND organization_id = NVL(x_item_id_record.to_organization_id,organization_id); -- Bug 12985791
2924:

Line 2940: FROM mtl_system_items

2936: * check for nvl(max(item_id),0).
2937: */
2938: SELECT NVL(MAX(organization_id), -9999)
2939: INTO x_organization_id
2940: FROM mtl_system_items
2941: WHERE inventory_item_id = x_item_id_record.item_id
2942: AND organization_id = NVL(x_item_id_record.to_organization_id, organization_id);
2943:
2944: IF (x_organization_id = -9999) THEN

Line 3025: x_inventory_item mtl_system_items.inventory_item_id%TYPE;

3021: ===========================================================================*/
3022: PROCEDURE validate_item_revision(
3023: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
3024: ) IS
3025: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
3026: x_progress VARCHAR2(3);
3027: x_revision_control_flag VARCHAR2(1);
3028: x_error_status VARCHAR2(1);
3029: BEGIN

Line 3041: FROM mtl_system_items msi

3037: 2, 'Y',
3038: 'N'
3039: )
3040: INTO x_revision_control_flag
3041: FROM mtl_system_items msi
3042: WHERE inventory_item_id = x_item_revision_record.item_id
3043: AND organization_id = x_item_revision_record.to_organization_id;
3044:
3045: IF x_revision_control_flag = 'N' THEN

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

3183: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
3184: x_unit_meas_lookup_code_lines po_lines_all.unit_meas_lookup_code%TYPE := NULL;
3185: x_progress VARCHAR2(3);
3186: x_new_conversion NUMBER := 0;
3187: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
3188: x_error_status VARCHAR2(1);
3189: BEGIN
3190: x_error_status := rcv_error_pkg.g_ret_sts_error;
3191: x_progress := '000';

Line 3216: FROM mtl_system_items_kfv

3212: -- must have a primary uom at this point since the first select stmt succeeded
3213:
3214: SELECT primary_unit_of_measure
3215: INTO x_primary_unit_of_measure
3216: FROM mtl_system_items_kfv
3217: WHERE inventory_item_id = x_uom_record.item_id
3218: AND organization_id = NVL(x_uom_record.to_organization_id, organization_id); -- Raj added as org_id is part of uk
3219:
3220: IF (NVL(x_uom_record.primary_unit_of_measure, x_primary_unit_of_measure) <> x_primary_unit_of_measure) THEN

Line 3302: FROM mtl_system_items msi

3298: 2, 'Y',
3299: 'N'
3300: )
3301: INTO x_revision_control_flag
3302: FROM mtl_system_items msi
3303: WHERE inventory_item_id = x_item_revision_record.item_id
3304: AND organization_id = x_item_revision_record.to_organization_id;
3305:
3306: /* If item is under revision control