APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_SYSTEM_ITEMS_B

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 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' ||