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

Line 739: FROM mtl_system_items_b ITEMS,

735: l_aog,
736: l_dmd_subinv_code,
737: l_dmd_loc_id,
738: l_uom
739: FROM mtl_system_items_b ITEMS,
740: ahl_schedule_materials ASM,
741: ahl_visits_b VST,
742: mtl_item_locations LOC
743: WHERE ITEMS.inventory_item_id = ASM.inventory_item_id

Line 1773: MTL_SYSTEM_ITEMS_B MSI

1769: MSI.INTERNAL_ORDER_ENABLED_FLAG
1770: INTO L_INVENTORY_ITEM,
1771: L_ISO_ENABLED_FLAG
1772: FROM AHL_SCHEDULE_MATERIALS ASM,
1773: MTL_SYSTEM_ITEMS_B MSI
1774: WHERE ASM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
1775: AND ASM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
1776: AND SCHEDULED_MATERIAL_ID = P_SCH_MTL_ID;
1777:

Line 2076: FROM mtl_system_items_b

2072: SELECT primary_uom_code,
2073: description
2074: INTO l_uom_code,
2075: l_item_description
2076: FROM mtl_system_items_b
2077: where INVENTORY_ITEM_ID = L_INVENTORY_ITEM_ID
2078: and rownum = 1;
2079: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2080: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'l_uom_code = ' || l_uom_code);

Line 3370: FROM mtl_system_items_b msi,

3366: SELECT msi.reservable_type,msi.inventory_item_id,
3367: msi.organization_id
3368: INTO l_reservable_flag,l_item_id,
3369: l_org_id
3370: FROM mtl_system_items_b msi,
3371: mtl_txn_request_lines mtrl
3372: WHERE mtrl.inventory_item_id = msi.inventory_item_id
3373: AND mtrl.organization_id = msi.organization_id
3374: AND mtrl.line_id = l_move_order_line_id;

Line 4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;

4438: l_trans_count NUMBER;
4439: l_error_msg VARCHAR2(240);
4440: l_error_code VARCHAR2(240);
4441:
4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;
4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;
4444: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4445:
4446: -- Record Type variables

Line 4458: mtl_system_items_kfv kfv,

4454: intf.ERROR_CODE,
4455: kfv.concatenated_segments,
4456: sni.FM_SERIAL_NUMBER
4457: FROM MTL_TRANSACTIONS_INTERFACE INTF,
4458: mtl_system_items_kfv kfv,
4459: MTL_SERIAL_NUMBERS_INTERFACE sni
4460: WHERE intf.TRANSACTION_INTERFACE_ID = p_txn_Id
4461: AND intf.inventory_item_id = kfv.inventory_item_id
4462: AND intf.organization_id = kfv.organization_id

Line 5155: FROM MTL_SYSTEM_ITEMS_KFV

5151: REVISION_QTY_CONTROL_CODE,
5152: LOCATION_CONTROL_CODE,
5153: primary_uom_code,
5154: concatenated_segments
5155: FROM MTL_SYSTEM_ITEMS_KFV
5156: WHERE ORGANIZATION_ID = p_org_id
5157: AND INVENTORY_ITEM_ID = p_item
5158: AND ENABLED_FLAG = 'Y'
5159: AND ((START_DATE_ACTIVE IS NULL)

Line 5172: FROM MTL_SYSTEM_ITEMS_KFV

5168: REVISION_QTY_CONTROL_CODE,
5169: LOCATION_CONTROL_CODE,
5170: primary_uom_code,
5171: concatenated_segments
5172: FROM MTL_SYSTEM_ITEMS_KFV
5173: WHERE ORGANIZATION_ID = p_org_id
5174: AND INVENTORY_ITEM_ID = p_item
5175: AND ENABLED_FLAG = 'Y'
5176: AND ((START_DATE_ACTIVE IS NULL)

Line 5223: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

5219: l_lot_control_dest NUMBER;
5220: l_location_control_src NUMBER;
5221: l_location_control_dest NUMBER;
5222: l_temp_number NUMBER;
5223: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;
5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;
5227: BEGIN

Line 5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

5220: l_location_control_src NUMBER;
5221: l_location_control_dest NUMBER;
5222: l_temp_number NUMBER;
5223: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;
5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;
5227: BEGIN
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5238: FROM mtl_system_items_kfv

5234: -- get the item name instead of id for error message purpose
5235: BEGIN
5236: SELECT concatenated_segments
5237: INTO l_concatenated_segments
5238: FROM mtl_system_items_kfv
5239: WHERE inventory_item_id = p_x_mtltfr_rec.Inventory_Item_Id
5240: AND organization_id = p_x_mtltfr_rec.dest_org_id;
5241: EXCEPTION
5242: WHEN OTHERS

Line 5652: ' FROM mtl_system_items_b ITEMS,' ||

5648: --for dynamic formation of query
5649: l_base_query VARCHAR2(8000) :=
5650: ' INSERT INTO AHL_APPLICABLE_INSTANCES(CSI_ITEM_INSTANCE_ID, POSITION_ID)' ||
5651: ' SELECT UNIQUE INST.instance_id, -1' ||
5652: ' FROM mtl_system_items_b ITEMS,' ||
5653: ' csi_item_instances INST,' ||
5654: ' mtl_serial_numbers SERIALS' ||
5655: ' WHERE ITEMS.inventory_item_id = INST.inventory_item_id' ||
5656: ' AND ITEMS.organization_id = INST.inv_master_organization_id' ||

Line 6294: FROM mtl_system_items_kfv

6290: CURSOR item_details_cur(c_inv_item_id NUMBER, c_org_id NUMBER)
6291: IS
6292: SELECT primary_uom_code,
6293: concatenated_segments
6294: FROM mtl_system_items_kfv
6295: WHERE inventory_item_id = c_inv_item_id
6296: AND organization_id = c_org_id;
6297: CURSOR mfg_err_msg_cur(C_LOOKUP_CODE NUMBER)
6298: IS