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 303: , mtl_system_items msi

299: FROM dual
300: WHERE exists (SELECT '1'
301: FROM wms_lpn_contents wlc
302: , wms_license_plate_numbers wlpn
303: , mtl_system_items msi
304: WHERE wlc.parent_lpn_id = wlpn.lpn_id
305: AND wlc.inventory_item_id = msi.inventory_item_id
306: AND msi.organization_id = p_org_id
307: AND wlpn.organization_id = p_org_id

Line 454: FROM mtl_system_items msi, rcv_shipment_lines rsl

450: , msi.revision_qty_control_code
451: INTO x_lot_control_code
452: , x_serial_control_code
453: , x_revision_control_code
454: FROM mtl_system_items msi, rcv_shipment_lines rsl
455: WHERE rsl.shipment_line_id = p_shipment_line_id
456: AND rsl.to_organization_id = p_org_id
457: AND msi.inventory_item_id = rsl.item_id
458: AND msi.organization_id = rsl.from_organization_id;

Line 1180: ,mtl_system_items msi

1176: ,l_po_line_location_id
1177: ,l_po_header_id
1178: FROM
1179: rcv_shipment_lines rsl
1180: ,mtl_system_items msi
1181: WHERE
1182: rsl.shipment_line_id = p_shipment_line_id
1183: AND rsl.shipment_header_id = p_shipment_header_id
1184: AND msi.inventory_item_id = rsl.item_id

Line 2282: mtl_system_items_kfv msik

2278: --performace fix. Bug 3444172. Modified the query below.
2279: SELECT DISTINCT pll.ship_to_organization_id
2280: INTO l_rti_rec.to_organization_id
2281: FROM po_line_locations pll, po_headers ph, po_lines pl,
2282: mtl_system_items_kfv msik
2283: WHERE ph.segment1 = l_rti_rec.document_num
2284: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2285: OR (msik.concatenated_segments = l_rti_rec.item_num
2286: AND l_rti_rec.item_id IS NULL))

Line 2322: FROM mtl_system_items_kfv msik,

2318: mp.organization_id
2319: INTO l_prim_uom_code,
2320: l_item_id,
2321: l_to_organization_id
2322: FROM mtl_system_items_kfv msik,
2323: mtl_parameters mp
2324: WHERE mp.organization_id = l_rti_rec.to_organization_id
2325: AND msik.inventory_item_id = l_rti_rec.item_id
2326: AND mp.organization_id = msik.organization_id;

Line 2335: FROM mtl_system_items_kfv msik,

2331: mp.organization_id
2332: INTO l_prim_uom_code,
2333: l_item_id,
2334: l_to_organization_id
2335: FROM mtl_system_items_kfv msik,
2336: mtl_parameters mp
2337: WHERE mp.organization_id = l_rti_rec.to_organization_id
2338: AND msik.concatenated_segments = l_rti_rec.item_num
2339: AND mp.organization_id = msik.organization_id;

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_code = l_rti_rec.to_organization_code
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_code = l_rti_rec.to_organization_code
2367: AND msik.concatenated_segments = l_rti_rec.item_num
2368: AND mp.organization_id = msik.organization_id;

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

3202:
3203: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3204: l_progress VARCHAR2(15) := '10';
3205: l_count NUMBER; --bug 5008139
3206: l_comms_nl_trackable_flag mtl_system_items.comms_nl_trackable_flag%type;--Bug6374074
3207: l_destination_type rcv_transactions_interface.destination_type_code%type;--Bug6374074
3208: l_clear_line_mark_id number;--Bug6374074( if l_clear_line_mark_id = 1 then clear the line_mark_id field
3209: -- else preserve the line_mark_id field
3210:

Line 3256: FROM mtl_system_items

3252: IF (l_count > 0) THEN
3253: --Bug 6374074, Checking whether the item is instal based tracked
3254: SELECT Nvl(comms_nl_trackable_flag,'N')
3255: INTO l_comms_nl_trackable_flag
3256: FROM mtl_system_items
3257: WHERE inventory_item_id = p_item_id
3258: AND organization_id= p_organization_id;
3259:
3260: IF l_comms_nl_trackable_flag = 'Y' THEN

Line 7804: FROM mtl_system_items

7800:
7801: IF (l_intransit_type = 1) THEN
7802: SELECT primary_uom_code
7803: INTO l_primary_uom
7804: FROM mtl_system_items
7805: WHERE inventory_item_id = l_rti_rec.item_id
7806: AND organization_id = l_rti_rec.to_organization_id;
7807:
7808: IF (l_debug = 1) THEN

Line 8031: FROM mtl_system_items

8027: l_revision_control_flag,
8028: -- OPMConvergence
8029: l_sec_uom_code
8030: -- OPMConvergence
8031: FROM mtl_system_items
8032: WHERE inventory_item_id = l_rti_rec.item_id
8033: AND organization_id = l_rti_rec.to_organization_id;
8034:
8035: l_progress := 'WMSINB-14190';

Line 10471: FROM mtl_system_items

10467: INTO l_primary_uom,
10468: l_primary_unit_of_measure,
10469: l_lot_control_code,
10470: l_serial_control_code
10471: FROM mtl_system_items
10472: WHERE inventory_item_id = p_item_id
10473: AND organization_id = p_to_org_id;
10474:
10475: l_progress := 'WMSINB-15816';

Line 18308: FROM MTL_SYSTEM_ITEMS

18304: , lot_status_enabled --Bug 4066234
18305: INTO L_LOT_CONTROL_CODE
18306: , L_SERIAL_NUMBER_CONTROL_CODE
18307: , l_lot_status_enabled --Bug 4066234
18308: FROM MTL_SYSTEM_ITEMS
18309: WHERE INVENTORY_ITEM_ID = L_ITEM_ID
18310: AND ORGANIZATION_ID = L_ORG_ID;
18311: /*
18312: ELSE --IF (l_discrete_transaction) THEN

Line 18316: from mtl_system_items msi , ic_item_mst iim

18312: ELSE --IF (l_discrete_transaction) THEN
18313: /** OPM change bug# 3061052
18314: select iim.lot_ctl,iim.sublot_ctl,iim.item_id,iim.item_no
18315: into l_opm_lot_ctl,l_opm_sublot_ctl,l_opm_item_id,l_item_no
18316: from mtl_system_items msi , ic_item_mst iim
18317: where msi.inventory_item_id = l_item_id
18318: and msi.organization_id = l_org_id
18319: and msi.segment1 = iim.item_no ;
18320:

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

18328: RAISE fnd_api.g_exc_error;
18329: END;
18330:
18331: IF (l_debug = 1) THEN
18332: print_debug('VALIDATE_LOT_SERIAL_INFO: MTL_SYSTEM_ITEMS query done :'||l_progress, 1);
18333: print_debug('INVCONV, Removing OPM specific fork :'||l_progress,1);
18334: --Bug 4066234
18335: print_debug('VALIDATE_LOT_SERIAL_INFO: Lot Control Code:'||l_lot_control_code,1);
18336: print_debug('VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:'||l_serial_number_control_code,1);