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.WMS_CONTAINER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1900: , mtl_system_items msi

1896: , msi.lot_control_code
1897: , msi.revision_qty_control_code
1898: FROM wms_license_plate_numbers wlpn
1899: , wms_lpn_contents wlc
1900: , mtl_system_items msi
1901: WHERE wlpn.organization_id = p_old_org_id
1902: AND wlpn.outermost_lpn_id = p_outermost_lpn_id
1903: AND wlc.parent_lpn_id = wlpn.lpn_id
1904: AND msi.inventory_item_id = wlc.inventory_item_id

Line 5825: FROM mtl_system_items

5821: SELECT unit_weight
5822: , weight_uom_code
5823: INTO l_lpn_tbl(l_tmp_i).tare_weight
5824: , l_lpn_tbl(l_tmp_i).tare_weight_uom_code
5825: FROM mtl_system_items
5826: WHERE organization_id = l_child_lpn.organization_id
5827: AND inventory_item_id = l_child_lpn.inventory_item_id;
5828: ELSE
5829: -- if there isn't a container item, empty lpns will have undefined

Line 5910: FROM mtl_system_items

5906: SELECT unit_weight
5907: , weight_uom_code
5908: INTO l_lpn_tbl(l_tmp_i).tare_weight
5909: , l_lpn_tbl(l_tmp_i).tare_weight_uom_code
5910: FROM mtl_system_items
5911: WHERE organization_id = empty_lpn_rec.organization_id
5912: AND inventory_item_id = empty_lpn_rec.inventory_item_id;
5913: ELSE
5914: -- if there isn't a container item, empty lpns will have undefined

Line 6701: FROM MTL_SYSTEM_ITEMS

6697: WHERE master_organization_id = p_organization_id
6698: AND load_item_id = p_source_item_id
6699: AND container_item_id IN
6700: (SELECT inventory_item_id
6701: FROM MTL_SYSTEM_ITEMS
6702: WHERE mtl_transactions_enabled_flag = 'Y'
6703: AND container_item_flag = 'Y'
6704: AND organization_id = p_organization_id);
6705:

Line 7266: FROM mtl_system_items

7262:
7263: -- Find primary UOM for this item
7264: SELECT primary_uom_code, lot_control_code
7265: INTO l_primary_uom, l_lot_control_code
7266: FROM mtl_system_items
7267: WHERE organization_id = p_organization_id
7268: AND inventory_item_id = p_inventory_item_id;
7269:
7270: IF ( p_source = LPN_CONTEXT_WIP ) THEN

Line 8287: FROM mtl_system_items

8283: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
8284: /* Get the primary UOM for the serialized item */
8285: SELECT primary_uom_code
8286: INTO l_temp_uom_code
8287: FROM mtl_system_items
8288: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
8289: AND organization_id = v_lpn_serial_content.current_organization_id;
8290:
8291: l_container_content_rec.parent_lpn_id := v_lpn_serial_content.lpn_id;

Line 8363: FROM mtl_system_items

8359: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
8360: /* Get the primary UOM for the serialized item */
8361: SELECT primary_uom_code
8362: INTO l_temp_uom_code
8363: FROM mtl_system_items
8364: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
8365: AND organization_id = v_lpn_serial_content.current_organization_id;
8366:
8367: l_container_content_rec.parent_lpn_id := v_lpn_serial_content.lpn_id;

Line 8838: FROM mtl_system_items

8834:
8835: -- Find the primary uom
8836: SELECT primary_uom_code
8837: INTO l_primary_uom
8838: FROM mtl_system_items
8839: WHERE organization_id = p_organization_id
8840: AND inventory_item_id = l_next_item_rec.inventory_item_id;
8841:
8842: LOOP

Line 9077: FROM mtl_system_items

9073: -- If next record is for a new item need to find the primary uom
9074: IF ( l_crnt_item_rec.inventory_item_id <> l_next_item_rec.inventory_item_id ) THEN
9075: SELECT primary_uom_code
9076: INTO l_primary_uom
9077: FROM mtl_system_items
9078: WHERE organization_id = p_organization_id
9079: AND inventory_item_id = l_next_item_rec.inventory_item_id; --bug12692678 change from l_crnt_item_rec to l_next_item_rec
9080: END IF;
9081: l_insert_item_rec := FALSE;

Line 9475: l_concatenated_segments mtl_system_items_b_kfv.concatenated_segments%TYPE;

9471: IS
9472: l_api_name CONSTANT VARCHAR2(30) := 'get_item_from_lpn';
9473: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9474: l_lpn_context NUMBER;
9475: l_concatenated_segments mtl_system_items_b_kfv.concatenated_segments%TYPE;
9476: BEGIN
9477:
9478: IF (l_debug = 1) THEN
9479: mdebug(' p_org : ' || p_org || ' p_lpn_id : ' || p_lpn_id || ' p_lpn_context : ' || p_lpn_context, G_INFO);

Line 9496: mtl_system_items_b_kfv msikfv

9492: IF l_lpn_context = 8 THEN
9493: SELECT msikfv.concatenated_segments
9494: INTO l_concatenated_segments
9495: FROM mtl_material_transactions_temp mmtt,
9496: mtl_system_items_b_kfv msikfv
9497: WHERE transfer_lpn_id IN
9498: (SELECT lpn_id
9499: FROM wms_license_plate_numbers
9500: START WITH lpn_id = p_lpn_id

Line 9511: mtl_system_items_b_kfv msikfv

9507: ELSE
9508: SELECT msikfv.concatenated_segments
9509: INTO l_concatenated_segments
9510: FROM WMS_LPN_CONTENTS wlc,
9511: mtl_system_items_b_kfv msikfv
9512: WHERE wlc.parent_lpn_id IN
9513: (SELECT lpn_id
9514: FROM wms_license_plate_numbers
9515: START WITH lpn_id = p_lpn_id