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

Line 699: FROM mtl_system_items

695: NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
696: INTO x_cascaded_table(n).primary_unit_of_measure,
697: x_cascaded_table(n).use_mtl_lot,
698: x_cascaded_table(n).use_mtl_serial
699: FROM mtl_system_items
700: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
701: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
702:
703: IF (g_asn_debug = 'Y') THEN

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

696: INTO x_cascaded_table(n).primary_unit_of_measure,
697: x_cascaded_table(n).use_mtl_lot,
698: x_cascaded_table(n).use_mtl_serial
699: FROM mtl_system_items
700: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
701: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
702:
703: IF (g_asn_debug = 'Y') THEN
704: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);

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

697: x_cascaded_table(n).use_mtl_lot,
698: x_cascaded_table(n).use_mtl_serial
699: FROM mtl_system_items
700: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
701: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
702:
703: IF (g_asn_debug = 'Y') THEN
704: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);
705: END IF;

Line 1957: FROM mtl_system_items

1953: ELSE
1954: BEGIN
1955: SELECT primary_unit_of_measure
1956: INTO temp_cascaded_table(current_n).primary_unit_of_measure
1957: FROM mtl_system_items
1958: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
1959: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
1960:
1961: IF (g_asn_debug = 'Y') THEN

Line 1958: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id

1954: BEGIN
1955: SELECT primary_unit_of_measure
1956: INTO temp_cascaded_table(current_n).primary_unit_of_measure
1957: FROM mtl_system_items
1958: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
1959: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
1960:
1961: IF (g_asn_debug = 'Y') THEN
1962: asn_debug.put_line('Primary UOM: ' || temp_cascaded_table(current_n).primary_unit_of_measure);

Line 1959: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;

1955: SELECT primary_unit_of_measure
1956: INTO temp_cascaded_table(current_n).primary_unit_of_measure
1957: FROM mtl_system_items
1958: WHERE mtl_system_items.inventory_item_id = temp_cascaded_table(current_n).item_id
1959: AND mtl_system_items.organization_id = temp_cascaded_table(current_n).to_organization_id;
1960:
1961: IF (g_asn_debug = 'Y') THEN
1962: asn_debug.put_line('Primary UOM: ' || temp_cascaded_table(current_n).primary_unit_of_measure);
1963: END IF;

Line 3126: -- from mtl_system_items

3122:
3123: -- null;
3124: -- select min(primary_unit_of_measure)
3125: -- into x_cascaded_table(n).primary_unit_of_measure
3126: -- from mtl_system_items
3127: -- where inventory_item_id = x_cascaded_table(n).item_id and
3128: -- organization_id = x_cascaded_table(n).to_organization_id;
3129: -- else
3130:

Line 4013: FROM mtl_system_items msi

4009: 2, 'Y',
4010: 'N'
4011: )
4012: INTO x_revision_control_flag
4013: FROM mtl_system_items msi
4014: WHERE inventory_item_id = x_item_revision_record.item_id
4015: AND organization_id = x_item_revision_record.to_organization_id;
4016:
4017: /* If item is under revision control

Line 4196: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;

4192: v_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
4193: n IN BINARY_INTEGER
4194: ) IS
4195: x_item_id NUMBER;
4196: x_primary_uom mtl_system_items.primary_unit_of_measure%TYPE := NULL;
4197: x_uom_class VARCHAR2(10);
4198: x_uom_count NUMBER(10);
4199: prim_uom_qty NUMBER;
4200: x_error_status VARCHAR2(1);

Line 4222: FROM mtl_system_items

4218: END IF;
4219:
4220: SELECT MAX(primary_unit_of_measure)
4221: INTO x_primary_uom
4222: FROM mtl_system_items
4223: WHERE mtl_system_items.inventory_item_id = v_cascaded_table(n).item_id
4224: AND mtl_system_items.organization_id = v_cascaded_table(n).to_organization_id;
4225:
4226: IF x_primary_uom IS NULL THEN

Line 4223: WHERE mtl_system_items.inventory_item_id = v_cascaded_table(n).item_id

4219:
4220: SELECT MAX(primary_unit_of_measure)
4221: INTO x_primary_uom
4222: FROM mtl_system_items
4223: WHERE mtl_system_items.inventory_item_id = v_cascaded_table(n).item_id
4224: AND mtl_system_items.organization_id = v_cascaded_table(n).to_organization_id;
4225:
4226: IF x_primary_uom IS NULL THEN
4227: IF (g_asn_debug = 'Y') THEN

Line 4224: AND mtl_system_items.organization_id = v_cascaded_table(n).to_organization_id;

4220: SELECT MAX(primary_unit_of_measure)
4221: INTO x_primary_uom
4222: FROM mtl_system_items
4223: WHERE mtl_system_items.inventory_item_id = v_cascaded_table(n).item_id
4224: AND mtl_system_items.organization_id = v_cascaded_table(n).to_organization_id;
4225:
4226: IF x_primary_uom IS NULL THEN
4227: IF (g_asn_debug = 'Y') THEN
4228: asn_debug.put_line('No Primary UOM for substitute item');

Line 4371: FROM mtl_system_items_kfv

4367: BEGIN
4368: IF (x_sub_item_id_record.substitute_item_num IS NOT NULL) THEN
4369: SELECT MAX(inventory_item_id)
4370: INTO x_sub_item_id_record.substitute_item_id
4371: FROM mtl_system_items_kfv
4372: WHERE concatenated_segments = x_sub_item_id_record.substitute_item_num;
4373: ELSE
4374: SELECT MAX(inventory_item_id)
4375: INTO x_sub_item_id_record.substitute_item_id

Line 4376: FROM mtl_system_items_kfv

4372: WHERE concatenated_segments = x_sub_item_id_record.substitute_item_num;
4373: ELSE
4374: SELECT MAX(inventory_item_id)
4375: INTO x_sub_item_id_record.substitute_item_id
4376: FROM mtl_system_items_kfv
4377: WHERE concatenated_segments = x_sub_item_id_record.vendor_item_num;
4378: END IF;
4379:
4380: IF (x_sub_item_id_record.substitute_item_id IS NULL) THEN