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

Line 320: , mtl_system_items msi

316: g_mixed_expense_lpn_id := p_lpn_id ;
317: END IF;
318: SELECT '1' INTO l_dummy
319: FROM wms_lpn_contents wlc
320: , mtl_system_items msi
321: , (SELECT lpn_id
322: FROM wms_license_plate_numbers wlpn2
323: WHERE wlpn2.organization_id = p_org_id
324: AND wlpn2.lpn_context <> G_LPN_CONTEXT_STORES

Line 478: FROM mtl_system_items msi, rcv_shipment_lines rsl

474: , msi.revision_qty_control_code
475: INTO x_lot_control_code
476: , x_serial_control_code
477: , x_revision_control_code
478: FROM mtl_system_items msi, rcv_shipment_lines rsl
479: WHERE rsl.shipment_line_id = p_shipment_line_id
480: AND rsl.to_organization_id = p_org_id
481: AND msi.inventory_item_id = rsl.item_id
482: AND msi.organization_id = rsl.from_organization_id;

Line 1204: ,mtl_system_items msi

1200: ,l_po_line_location_id
1201: ,l_po_header_id
1202: FROM
1203: rcv_shipment_lines rsl
1204: ,mtl_system_items msi
1205: WHERE
1206: rsl.shipment_line_id = p_shipment_line_id
1207: AND rsl.shipment_header_id = p_shipment_header_id
1208: AND msi.inventory_item_id = rsl.item_id

Line 2311: mtl_system_items_kfv msik

2307: --performace fix. Bug 3444172. Modified the query below.
2308: SELECT DISTINCT pll.ship_to_organization_id
2309: INTO l_rti_rec.to_organization_id
2310: FROM po_line_locations pll, po_headers ph, po_lines pl,
2311: mtl_system_items_kfv msik
2312: WHERE ph.segment1 = l_rti_rec.document_num
2313: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2314: OR (msik.concatenated_segments = l_rti_rec.item_num
2315: AND l_rti_rec.item_id IS NULL))

Line 2351: FROM mtl_system_items_kfv msik,

2347: mp.organization_id
2348: INTO l_prim_uom_code,
2349: l_item_id,
2350: l_to_organization_id
2351: FROM mtl_system_items_kfv msik,
2352: mtl_parameters mp
2353: WHERE mp.organization_id = l_rti_rec.to_organization_id
2354: AND msik.inventory_item_id = l_rti_rec.item_id
2355: AND mp.organization_id = msik.organization_id;

Line 2364: FROM mtl_system_items_kfv msik,

2360: mp.organization_id
2361: INTO l_prim_uom_code,
2362: l_item_id,
2363: l_to_organization_id
2364: FROM mtl_system_items_kfv msik,
2365: mtl_parameters mp
2366: WHERE mp.organization_id = l_rti_rec.to_organization_id
2367: AND msik.concatenated_segments = l_rti_rec.item_num
2368: AND mp.organization_id = msik.organization_id;

Line 2380: FROM mtl_system_items_kfv msik,

2376: mp.organization_id
2377: INTO l_prim_uom_code,
2378: l_item_id,
2379: l_to_organization_id
2380: FROM mtl_system_items_kfv msik,
2381: mtl_parameters mp
2382: WHERE mp.organization_code = l_rti_rec.to_organization_code
2383: AND msik.inventory_item_id = l_rti_rec.item_id
2384: AND mp.organization_id = msik.organization_id;

Line 2393: FROM mtl_system_items_kfv msik,

2389: mp.organization_id
2390: INTO l_prim_uom_code,
2391: l_item_id,
2392: l_to_organization_id
2393: FROM mtl_system_items_kfv msik,
2394: mtl_parameters mp
2395: WHERE mp.organization_code = l_rti_rec.to_organization_code
2396: AND msik.concatenated_segments = l_rti_rec.item_num
2397: AND mp.organization_id = msik.organization_id;

Line 3259: l_comms_nl_trackable_flag mtl_system_items.comms_nl_trackable_flag%type;--Bug6374074

3255:
3256: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3257: l_progress VARCHAR2(15) := '10';
3258: l_count NUMBER; --bug 5008139
3259: l_comms_nl_trackable_flag mtl_system_items.comms_nl_trackable_flag%type;--Bug6374074
3260: l_destination_type rcv_transactions_interface.destination_type_code%type;--Bug6374074
3261: l_clear_line_mark_id number;--Bug6374074( if l_clear_line_mark_id = 1 then clear the line_mark_id field
3262: -- else preserve the line_mark_id field
3263:

Line 3309: FROM mtl_system_items

3305: IF (l_count > 0) THEN
3306: --Bug 6374074, Checking whether the item is instal based tracked
3307: SELECT Nvl(comms_nl_trackable_flag,'N')
3308: INTO l_comms_nl_trackable_flag
3309: FROM mtl_system_items
3310: WHERE inventory_item_id = p_item_id
3311: AND organization_id= p_organization_id;
3312:
3313: IF l_comms_nl_trackable_flag = 'Y' THEN

Line 8114: FROM mtl_system_items

8110:
8111: IF (l_intransit_type = 1) THEN
8112: SELECT primary_uom_code
8113: INTO l_primary_uom
8114: FROM mtl_system_items
8115: WHERE inventory_item_id = l_rti_rec.item_id
8116: AND organization_id = l_rti_rec.to_organization_id;
8117:
8118: IF (l_debug = 1) THEN

Line 8342: FROM mtl_system_items

8338: l_revision_control_flag,
8339: -- OPMConvergence
8340: l_sec_uom_code
8341: -- OPMConvergence
8342: FROM mtl_system_items
8343: WHERE inventory_item_id = l_rti_rec.item_id
8344: AND organization_id = l_rti_rec.to_organization_id;
8345:
8346: l_progress := 'WMSINB-14190';

Line 10322: from mtl_system_items

10318: print_debug('This is a WMS enabled Org. Changes for bug # 10396979 ',1);
10319: if l_rti_rec.item_id is not null then
10320: begin
10321: select LOT_CONTROL_CODE into l_wms_lot
10322: from mtl_system_items
10323: where inventory_item_id = l_rti_rec.item_id
10324: and organization_id = l_rti_rec.to_organization_id
10325: and rownum = 1;
10326: exception

Line 10948: FROM mtl_system_items

10944: INTO l_primary_uom,
10945: l_primary_unit_of_measure,
10946: l_lot_control_code,
10947: l_serial_control_code
10948: FROM mtl_system_items
10949: WHERE inventory_item_id = p_item_id
10950: AND organization_id = p_to_org_id;
10951:
10952: l_progress := 'WMSINB-15816';

Line 18487: FROM mtl_system_items msi, rcv_transactions_interface rti

18483: */
18484: /* BEGIN
18485: SELECT msi.serial_number_control_code
18486: INTO x_serial_number_control_code
18487: FROM mtl_system_items msi, rcv_transactions_interface rti
18488: WHERE msi.inventory_item_id = rti.item_id
18489: AND msi.organization_id = rti.to_organization_id
18490: AND rti.interface_transaction_id = p_rti_id;
18491: EXCEPTION

Line 19325: FROM MTL_SYSTEM_ITEMS

19321: , lot_status_enabled --Bug 4066234
19322: INTO L_LOT_CONTROL_CODE
19323: , L_SERIAL_NUMBER_CONTROL_CODE
19324: , l_lot_status_enabled --Bug 4066234
19325: FROM MTL_SYSTEM_ITEMS
19326: WHERE INVENTORY_ITEM_ID = L_ITEM_ID
19327: AND ORGANIZATION_ID = L_ORG_ID;
19328: /*
19329: ELSE --IF (l_discrete_transaction) THEN

Line 19333: from mtl_system_items msi , ic_item_mst iim

19329: ELSE --IF (l_discrete_transaction) THEN
19330: /** OPM change bug# 3061052
19331: select iim.lot_ctl,iim.sublot_ctl,iim.item_id,iim.item_no
19332: into l_opm_lot_ctl,l_opm_sublot_ctl,l_opm_item_id,l_item_no
19333: from mtl_system_items msi , ic_item_mst iim
19334: where msi.inventory_item_id = l_item_id
19335: and msi.organization_id = l_org_id
19336: and msi.segment1 = iim.item_no ;
19337:

Line 19349: print_debug('VALIDATE_LOT_SERIAL_INFO: MTL_SYSTEM_ITEMS query done :'||l_progress, 1);

19345: RAISE fnd_api.g_exc_error;
19346: END;
19347:
19348: IF (l_debug = 1) THEN
19349: print_debug('VALIDATE_LOT_SERIAL_INFO: MTL_SYSTEM_ITEMS query done :'||l_progress, 1);
19350: print_debug('INVCONV, Removing OPM specific fork :'||l_progress,1);
19351: --Bug 4066234
19352: print_debug('VALIDATE_LOT_SERIAL_INFO: Lot Control Code:'||l_lot_control_code,1);
19353: print_debug('VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:'||l_serial_number_control_code,1);

Line 29448: FROM mtl_system_items

29444: THEN
29445:
29446: SELECT primary_uom_code
29447: INTO l_pr_UoM_code
29448: FROM mtl_system_items
29449: WHERE inventory_item_id = p_item_id
29450: AND organization_id = p_organization_id ;
29451:
29452: l_progress :=20;