APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_PARAMETERS

Line 2169: FROM mtl_parameters

2165: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'Getting material account Id');
2166: END IF;
2167: SELECT material_account
2168: INTO l_material_account
2169: FROM mtl_parameters
2170: where ORGANIZATION_ID = l_demand_org_id;
2171: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2172: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'l_material_account = ' || l_material_account);
2173: end if;

Line 5660: ' FROM mtl_parameters mp, inv_organization_info_v io' ||

5656: ' AND ITEMS.organization_id = INST.inv_master_organization_id' ||
5657: ' AND INST.serial_number = SERIALS.serial_number' ||
5658: ' AND INST.inventory_item_id = SERIALS.inventory_item_id' ||
5659: ' AND EXISTS (SELECT 1' ||
5660: ' FROM mtl_parameters mp, inv_organization_info_v io' ||
5661: ' WHERE mp.master_organization_id = ITEMS.organization_id' ||
5662: ' AND mp.organization_Id = io.organization_id' ||
5663: ' AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())';
5664: